2024-01-17
461 reads
2024-01-17
461 reads
2024-01-10
523 reads
2023-11-27
5,847 reads
It is strange that one can ask simple questions about extended events or Hekaton at professional events and conferences without feeling embarrassed, yet nobody likes to ask vital questions about SQL Server primary keys and foreign keys. Fear not, here are 13 questions you were too shy to ask, answered.
2014-10-14
9,933 reads
I inherited a database that was getting large and not performing well. After adding primary keys life got better.
2014-06-30
14,676 reads
Every database developer uses keys, but without always understanding all the ramifications. They come with few hard and fast rules, but if you get them right from the start with a database design, the whole process of database development is simpler, and the result is likely to perform better. We asked Phil for advice, little knowing that the explanation might take a while.
2013-12-19
5,005 reads
Recently I was asked to find all the Primary keys that are not clustered Indexes in the database. I constructed the below script which will help us to locate the primary keys in the database which are not clustered index.
2013-09-18 (first published: 2013-09-04)
1,921 reads
2013-01-29
2,613 reads
This code helps in finding Primary Keys for all tables in a database.
2012-10-02 (first published: 2012-09-04)
1,430 reads
Output table of gaps in a primary key across multiple databases on same, remote and/or linked servers.
2012-02-13 (first published: 2011-08-12)
941 reads
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
Comments posted to this topic are about the item Create an HTML Report on...
hello everybody, new here and this is my first question I have a table...
Hi everyone I am a bit stuck on how to write this query. Below...
When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?
See possible answers