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

711 reads

Blogs

Power BI – Hungry Median – Aggregations

By

Introduction In my last blog post, I have addressed an issue with DAX Median...

Inspector 2.4 now available

By

All the changes for this release can be found in the Github Project page...

Basic JSON Queries–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

SSIS Startup directory not found

By wburke 85918

This seems to be a common issue throughout my packages. Anywhere I try to...

What is the best way to create events from table inserts in SQL Server

By Joseph Termine

I have a SQL 20XX database in an on-premise data center that has a...

HA in General Purpose Managed Instance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item HA in General Purpose Managed...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers