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

91 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

701 reads

Blogs

Information Measurement with SQL Server Part 4.5: The Squared L2 Family of Distances

By

By Steve Bolton …………In the last two installments of this series of amateur self-tutorials...

Security Learning Pathway at PASS Summit.

By

This year PASS is trying something new at PASS Summit. There are going to...

Pathways to Progress

By

One of the most significant and hardest challenges we face as data professionals (or...

Read the latest Blogs

Forums

error Output File cleanup does not delete files script d'olla

By abdalah.mehdoini

Hello everyone, I use olla scripts in my backup and maintenance operations there is...

Help with a stored procedure

By sridharkannan7

I have a table "Mytable" containing a list of IDs. There is a web...

Need to perform leaf level aggregation

By morbius82000

So I have a DW with  a table with some pre-aggregated scores (not my...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers