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

93 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

712 reads

Blogs

Daily Coping 5 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Microsoft Ignite Announcements 2021

By

Microsoft Ignite has always announced many new products and new product features, and this year...

Daily Coping 4 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Missing Integration Services Catalogs folder in SSMS

By giles.clapham

I've developed an SSIS Package that I need to deploy to a remote server,...

Distinguish Between Identical Rows

By Neil Burton

We're in the middle of a project to load IIS log files into a...

Snowflake ODBC to SQL Ole Destination ERROR

By darkangelBDF

Hi there, everyone. We've create and SSIS package that gets data from a Snowflake...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers