2014-08-11 (first published: 2014-05-28)
1,675 reads
2014-08-11 (first published: 2014-05-28)
1,675 reads
2014-07-11
2,680 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,190 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,033 reads
The script give you the list of all users and their respective Server roles
2014-04-02 (first published: 2014-03-11)
1,543 reads
2014-03-25
2,182 reads
This script is an example of how to use Sequence, similar to Identity.
2014-03-24 (first published: 2014-02-25)
1,334 reads
2014-02-27 (first published: 2014-02-11)
1,882 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,361 reads
By Steve Jones
It’s been a good week at SQL Bits. This is my favorite conference, and...
V Joyful Craftsmen máme skvělý bonus (tzv. SGP), v rámci, kterého se můžeme vzdělávat v...
By HeyMo0sh
I love KQL so much I even made a video and if you compare...
Please suggest practice on SQL Server RLS On the database level, defined users with...
Hello, I have 3 SSIS packages having connection manager defined with a userA. These...
Hi Experts, What is 'optimize for ad hoc workloads' do mean in short? I...