Quick solution

😎

USE master;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'tempdb.dbo.temp_result') IS NOT NULL DROP TABLE tempdb.dbo.temp_result;

CREATE TABLE tempdb.[dbo].[temp_result]

(

[DATABASE_NAME] [nvarchar](128) NOT NULL

,[TableName] [sysname] ...

Thank you Tom for this piece!

😎

After reading it I do have few concerns about the findings:

1. The execution times suggest that a covering index for the aggregation is in place,...

charipg (12/28/2015)

---

Hi,

I need to set run time(dynamic) values for Startdate and Enddate in below query

Enddate should be currentdate and Startdate should be minus 7 days of...

Forgot to post the implementation of the "digits only" logic as a subquery without the using a function, here is one that fits the previously posted test harness. This code...

Quick solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

SELECT

X.[DATABASE]

,X.[PARAMETER]

,X.[VALUE]

FROM sys.databases SDB

CROSS APPLY

(

...

Quick suggestion, use FOR XML PATH rather than EXPLICIT

😎

The Chuck Norris/Brute-force method is many times slower apart from other limitations such as input length. For certain this...

Luis Cazares (12/28/2015)

---

A small correction from Eirikur's code and two additional options.

SELECT

SI.invno

FROM dbo.TBL_SALES_ITEMS SI

WHERE SI.SIC IN ('111','222')

GROUP BY SI.invno

HAVING COUNT( DISTINCT SI.SIC)...

Alan.B (12/28/2015)

---

The most common/easiest to fix mistakes:

Someone beat me to it but NOLOCK table hints are the #1 mistake I have seen. I would go so far as to say...

You are very welcome.

😎

Ed Wagner (12/28/2015)

---

Nice job, Eirikur. I was working on the same approach, but was shooting for = 0 instead of < 1. The ceiling of the decimal division...

This is straight forward, select from the table where (Row_Number % Divisor) is less than one, rounding will not give the right results because of the loss of precicion.

😎

Quick sample

;WITH...

Eric M Russell (12/28/2015)

---

In addition to what's already been mentioned above:

On the fly data type conversion and transformations, both explicit and implicit

Distributed queries (ie: joining tables between multiple instances...

SQL Server is fully ACID (Atomicity, Consistency, Isolation, Durability), if you need functionality outside the ACID then use Jeff's suggestion and output the log to a file, that temp table...

Another wild guess

😎

USE tempdb;

GO

IF OBJECT_ID(N'dbo.TBL_SALES_ITEMS') IS NOT NULL DROP TABLE dbo.TBL_SALES_ITEMS;

CREATE TABLE dbo.TBL_SALES_ITEMS

(

SI_ID INT IDENTITY(1,1) ...