- a simple and handy script that finds what differences might exists between the fields in your database that have the same name.I was wondering why my execution plans where different for tables with the same field names and the same indexes,statistics etc... because the syetem was converting my fields in the WHERE statement. - […]
2003-06-08
107 reads
2 steps:step 1 => create a table in master database called BlockCheckstep 2 => create the stored procedure in master called BLOCK_CHECK @database_name varchar(20)What SP does:- it gets the spid that is blocked + info about it (like what it does at the moment it is blocked)- it gets the spid that acts as a […]
2003-06-05
724 reads
Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...
By Steve Jones
Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...
In this post, I’ll walk you through a T-SQL script that creates application-consistent snapshots...
I have a tabular cube, with myself included in one of the roles. I...
Hi all, I’ve just open‑sourced T‑TEST, a tiny alternative to tSQLt that lives...
Comments posted to this topic are about the item Helpful Management Studio Settings and...
What is the minimal number of parameters to add a linked server with sp_addlinkedserver?
See possible answers