2017-05-10 (first published: 2017-05-02)
367 reads
2017-05-10 (first published: 2017-05-02)
367 reads
Warm the cache with a particular table by reading it into memory.
2016-11-25 (first published: 2016-11-14)
857 reads
Add 3 columns, duration in seconds,Pagecount and fragmentation. For people like me who don't enjoy querying XML.
2016-10-31 (first published: 2015-11-12)
3,240 reads
Get total access,updates, rowlocks,pagelocks, stats date,rowcount for all tables or specific table by partition
2016-02-04 (first published: 2016-01-22)
894 reads
In an OLTP DB, other than an autogenerated Identity , there should be something else on the table which makes the non-identity data unique, as in, unique if you had to drop the ID column.
2016-02-03 (first published: 2016-01-22)
492 reads
Find missing Foreign Keys by name, only reference single column primary keys which are on top of an identity,also find where column names reference table with column name ='ID'.
2016-02-01 (first published: 2016-01-21)
1,079 reads
This will log output of estimate compression for both PAGE and ROW for all tables and indexes
2015-12-10 (first published: 2015-11-20)
2,442 reads
Find Tables with identity, which should have PK with 1 column but have a PK with multiple columns or where the unique identity is contained in other indexes.
2015-11-25 (first published: 2015-11-04)
143 reads
Find Tables with identity, which should have PK with 1 column but have a PK which is clustered but has multiple columns.
2015-11-24 (first published: 2015-11-04)
940 reads
By Steve Jones
I flew to Amsterdam last night and hopefully by the time this publishes I’ll...
By Chris Yates
In every organization there is a hidden currency more valuable than capital, more enduring...
Update for SQL Server 2025: This post and the GitHub repo have been updated for...
Looking for laptops without heavy investment? Laptop on rent in Noida is ideal for...
hi everyone I am getting an error when I add a variable to a...
Comments posted to this topic are about the item How to Use SQL Server...
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers