Start by having a look at these two articles

😎

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]

Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url]

Quick question, have you tested if @i ever becomes NULL?

😎

WHILE @i IS NOT NULL

...

SELECT @i = min(Id) FROM @Alarms WHERE id > @i

I prefer using Extended Events when working with MARS result sets, little bit more work but cleaner to process especially if you take the result straight into Excel or PowerBI.

😎

One...

sqlguy-736318 (12/5/2016)

---

I created a console app in .NET to call a sproc 25 times concurrently. Max return time was 999ms, min was 20ms and avg was 565ms.

Then I exec'd...

Quick question, why are you using float?

😎

The value returned is exactly the same, but in scientific notation. You can change the last parameter of the Convert function which will...

rodjkidd (12/5/2016)

---

Eirikur and Chris,

I'm in London all week, and free lunch times. Although today I'm waiting for the Royal Albert Hall booking line to open...

So let me know when you...

BOR15K (12/5/2016)

---

I have a table of several millions of records for flight ticket. One of the indices is Flight Ticket, so when user searches for ticket 1234567 or 123456% all...

Tatay_2016 (11/25/2016)

---

Hi,

First time here. I'm the admin of a small business with a mssql database that is remotely hosted by our website provider. I need to import/export...

ScottPletcher (12/2/2016)

---

Personally I've had much lesser delays/stalls using this command:

ALTER DATABASE SQLTRIX SET OFFLINE WITH ROLLBACK_IMMEDIATE;

And you can get into devilish issues with "SINGLE_USER". You need to make sure...

The DBCC TRACESTATUS lists out active trace flags, has nothing to do with traces....

Thank you for this write up Kenneth.

😎

Quick suggestion

😎

USE TEEST;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(SD_ID,SD_TEXT) AS

(

SELECT 1,'AA' UNION ALL

SELECT 2,'BB' UNION ALL

SELECT 3,'CC'

)

SELECT

...

And the output?

😎

Andrew P (11/29/2016)

---

I've identified one of our databases has significant corruption, including several extent allocation issues and SGAM allocation issues.

After doing some research on this, I'm aware I can identify...

Mike Scalise (11/29/2016)

---

Hi,

Has anyone been able to successfully use Ola Hallengren's maintenance scripts to only clean up old backups and not take a new backup? I have full backups running...