Technical Article

detect different datatypes

-  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

96 reads

Technical Article

blocked  and blocker  spid and details

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 […]

4 (1)

2003-06-05

713 reads

Blogs

Daily Coping 3 Oct 2022

By

Today’s coping tip is to write down three things you appreciate about yourself. I...

Scary Scalar Functions - Part Four: Your Environment

By

Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...

Being a script magpie

By

Last month (I ran just a little bit late writing this, it was meant...

Read the latest Blogs

Forums

Shrink database issue

By don075

In my database, I have few temp tables that total up to 50GB in...

Migration of simple SPs from 120 to 150 COMPATIBILITY_LEVEL issue.

By serverdba

Migration of simple SPs from 120 to 150 COMPATIBILITY_LEVEL issue. Execution time for the...

Referencing a SQLCMD variable in a Post Deployment script using SqlPackage

By Weegee71

Ive got a Database project running in JetBrains Rider. The project publishes a DACPAC...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers