2014-08-11 (first published: 2014-05-28)
1,745 reads
2014-08-11 (first published: 2014-05-28)
1,745 reads
2014-07-11
2,684 reads
THis script will generate the Drop and create script for all user define table type
2014-04-18 (first published: 2014-03-25)
1,196 reads
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,038 reads
The script give you the list of all users and their respective Server roles
2014-04-02 (first published: 2014-03-11)
1,550 reads
2014-03-25
2,185 reads
This script is an example of how to use Sequence, similar to Identity.
2014-03-24 (first published: 2014-02-25)
1,340 reads
2014-02-27 (first published: 2014-02-11)
1,889 reads
Get the list of the tables on the server which dont have the clustered index.
2014-02-24 (first published: 2014-02-17)
1,372 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers