2017-05-10 (first published: 2017-05-02)
363 reads
Warm the cache with a table and its indexes
Warm the cache with a particular table by reading it into memory.
2016-11-25 (first published: 2016-11-14)
808 reads
View for Ola Hallengren CommandLog
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,107 reads
Index stats with key,included columns, size - all you can eat
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)
887 reads
Design : Find table with Identities with missing unique constraints
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)
490 reads
Design : Find and script out Missing Foreign Keys
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,073 reads
Estimate compression for all tables and indexes with both Row and Page
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,374 reads
Design Errors : PK's with multiple columns on table with identity
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)
140 reads
Design Errors : PK's with multiple columns on table with identity
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)
937 reads
Blogs
Monday Monitor Tips: Looking Back in Time
By Steve Jones
Often we find out about a problem reported by a customer after the incident...
Can You Tell Why a Plan Didn’t Go Parallel?
Let’s face it, most of the time, you probably don’t want your SQL Server...
Friday Flyway Tips: State-based deployment with Flyway Teams
By Steve Jones
I was asked about state-based deployments in Flyway Teams, so I decided to show...
Forums
The Table Backup
Comments posted to this topic are about the item The Table Backup
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Monoliths and Microservices
Comments posted to this topic are about the item Monoliths and Microservices
Question of the Day
The Table Backup
I run this code in SQL Server 2022. What happens?
BACKUP TABLE beercount TO DISK = 'beercount.bak'See possible answers