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

92 reads

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

702 reads

Blogs

Quick Blog: Making the Power BI PowerShell cmdlets easier to use

By

One of the top reasons I love PowerShell so much is that from the...

Trouble writing? Join the club. #JustWriteTech

By

I was talking with  a couple of excellent SQL people* recently, and we were bemoaning...

Check Query Progress with Live Query Stats

By

This is something I touched on back in 2017 a little after the Live...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

how to list index corresponding to statistics using select statement

By ebooklub

Hi , with query bellow I  can list DTA  statistic that is not updated...

Get files based on SQL results

By Jay@Work

I have a sql task which queries a database and returns a result set...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers