2014-08-11 (first published: 2014-05-28)
1,698 reads
2014-08-11 (first published: 2014-05-28)
1,698 reads
2014-07-11
2,681 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,192 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,545 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,885 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,363 reads
In the technologically driven world of 2024, more individuals are finding themselves drawn towards the...
By Steve Jones
I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...
In this series of blog posts, we’re diving into how to use the Pure...
Hello Gurus for one use case we converted the code to use temp tables...
CREATE TABLE #tempdblogin ( lastcheck nvarchar(100) ) EXEC sp_MSforeachdb 'USE ? insert into #tempdblogin...
I am considering implementing an Azure Postgres DB for use in a part of...