-
Find All Tables Without A Primary Key
SQL script to find all the tables in a database which are missing a primary key.
-
Finding SQL Server Foreign Keys – The fast way
Need a list of Foreign Keys in your database. This simple query will deliver quickly and efficiently.
-
SQL Server Read Committed Snapshot – Is it on?
How do you check whether read committed snapshot is on or off for a particular SQL Server database using SQL Server Management Studio? We’ve never been able to find it but this quick T-SQL query will show you the answer. (Also check out our post on checking whether Snapshot Isolation is on):
-
SQL Server Snapshot Isolation – Is it on?
How do you know whether snapshot isolation is on in SQL Server? A quick T-SQL query will show you the answer.