Useful tips for everyday
What is a functional dependency in database? A functional dependency (FD) is a relationship between two attributes, typically between the PK and other non-key attributes…
How can I get column names from a table in SQL? Tip Query to get all column names from database table in SQL… SELECT COLUMN_NAME.…
How do I replace a blank null date in tableau? The steps are simple: Change the data type of the Date to a String (right-click…
Should DBA have root access? It is an inherent design feature of the software. If this is a breach of your policies then the policies…
How does a query plan work? A query plan (or query execution plan) is a sequence of steps used to access data in a SQL…
How do I get just the year from datetime? This function takes only one argument – a date or date and time. This can be…
What are naming conventions in a database? I’ve already stated it in the intro, but more generally, a naming convention is a set of rules…
How do I give a column a default value? In Object Explorer, right-click the table with columns for which you want to change the scale…
What does connection pool means? Connection pooling means that connections are reused rather than created each time a connection is requested. To facilitate connection reuse,…
How to speed up join stack overflow in SQL Server? Put indexes on attributeId. Or, make sure indexes exist where attributeId is the first column…