2014-08-11 (first published: 2014-05-28)
1,646 reads
2014-08-11 (first published: 2014-05-28)
1,646 reads
2014-07-11
2,676 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,180 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,028 reads
The script give you the list of all users and their respective Server roles
2014-04-02 (first published: 2014-03-11)
1,535 reads
2014-03-25
2,178 reads
This script is an example of how to use Sequence, similar to Identity.
2014-03-24 (first published: 2014-02-25)
1,320 reads
2014-02-27 (first published: 2014-02-11)
1,869 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,351 reads
My updated course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want...
By James-Serra
I sometimes get asked from customers if they should use a star schema or...
By Steve Jones
I learned a new trick from Andrew Pruski. In a blog on avoiding PowerPoint,...
How to update check exist column by value 1 where partid exist on table...
Hello All I was tasked with setting up a new instance on the same...
Comments posted to this topic are about the item Monitor SQL Server Error Logs...