2016-10-21 (first published: 2015-05-12)
2,407 reads
2016-10-21 (first published: 2015-05-12)
2,407 reads
2016-05-25 (first published: 2014-03-06)
2,222 reads
This can be used for data warehouses as well as truncating table with foreign key constraints.
2016-04-08 (first published: 2014-07-07)
2,617 reads
This script shows the total time between two dates.
2016-03-29 (first published: 2014-07-09)
3,075 reads
For successful run, Your SQL Server service account should have permission to old location & new location
2015-05-27 (first published: 2015-05-10)
1,048 reads
Extract only integers or characters from alphanumeric :
2014-10-07 (first published: 2014-09-05)
1,513 reads
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Comments posted to this topic are about the item DBCC CHECKIDENT
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Hi, our peer who owns a remote mysql server from which we extract warehouse...
What is returned as a result set when I run this command without a new seed value?
See possible answers