2014-08-11 (first published: 2014-05-28)
1,744 reads
Mitesh Oswal
Get the defination of all table type in database
THis script will generate the Drop and create script for all user define table type
2014-04-18 (first published: 2014-03-25)
1,195 reads
Get the Column level difference for 2 database
The query will help to get the column level difference for 2 database(Like Prod and Dev database). This help us to verify what are the column changes has been done in dev environment after Prod deployment.
2014-04-10 (first published: 2014-03-11)
1,037 reads
Get the all user and their server role
The script give you the list of all users and their respective Server roles
2014-04-02 (first published: 2014-03-11)
1,549 reads
Using Seqence Container instead of Identity
This script is an example of how to use Sequence, similar to Identity.
2014-03-24 (first published: 2014-02-25)
1,339 reads
2014-02-27 (first published: 2014-02-11)
1,888 reads
Get the all the tables on the server which do not have Clustered index
Get the list of the tables on the server which dont have the clustered index.
2014-02-24 (first published: 2014-02-17)
1,369 reads
Blogs
Build Recovery into the Design
By Brian Kelley
It's like disaster recovery (and business continuity) planning is the end-of-term research paper that...
dataMinds Connect 2024 – Session Materials
The slides and scripts for my session “Tackling the Gaps & Islands Problem with...
Want to Supercharge Your Business? SQL is Your Secret Weapon.
Look, we all know data is king these days. But having mountains of data...
Forums
Everything is Code
Comments posted to this topic are about the item Everything is Code
Statistics Histograms
Comments posted to this topic are about the item Statistics Histograms
Log backup does not contain checksum - when I told SQL to include it?
I'm using Ola's backup script to back up my databases. One database has recently...
Question of the Day
Statistics Histograms
I have a statistics objects with 2 key columns from my tables. How many histograms and their type are stored?
See possible answers