Useful tips for everyday
How do breakpoints work in SSMS? Toggle a Breakpoint Click the gray bar to the left side of the Transact-SQL statement. Alternatively, either highlight any…
Is the report Folder shared with all users? Below screenshot shows the users with folder is shared. I have shared it with myself as manager.…
What is the meaning of where 1/2 in SQL query? This type of command is usually used to copy the structure of one table to…
What are rules in SQL Server? Creates an object called a rule. When bound to a column or an alias data type, a rule specifies…
What are SCD Type 2 tables? A Type 2 SCD retains the full history of values. When the value of a chosen attribute changes, the…
How do I find the SQL instance name in PowerShell? The Get-ChildItem cmdlet is used to list the SQL instances of the server. We can…
Why do I get ” invalid date format ” error? About 20 datapumps. All contain one ‘OLE DB Source’ (sql server 9.00.4035.00) and copy data…
How do you get max from subquery? To find the maximum value of a column, use the MAX() aggregate function; it takes a column name…
How do I get SQL Server out of single-user mode? To set a database to single-user mode In Object Explorer, connect to an instance of…
Why does everything need to be normalized? To “normalize” something is to make it normal and natural in everyday life, and there are certain taboo…