After removing TDE did you ensure that the decryption process was complete before you restarted the box? What was the size of the actual data in the transaction log at...

Well done Drew. Especially nice given the added flexibility. 2 very minor improvements:

WITH Tally(n) AS (

--more efficient "small" tally table 🙂

SELECT n

FROM ( VALUES(1), (2), (3), (4), (5), (6), (7),...

A Numbers table of course! 😛

1-n with clustered index on that column. Gets you the same thing as the virtual one using the...

Here's a solution using a table of numbers (you can create your own or use a virtual one) and my favorite TSQL word CASE. 🙂 Coffee hasn't kicked in and...

abbogus (11/3/2016)

---

Kevin,

Yes, there is data present for my job to read. 400+ records existed for each day.

Right now, my COGNOS guy is checking event logs to see if something was...

hegdesuchi (11/3/2016)

---

I have two tables with below data

table 1

Id name company

1 aaa yyy

1 aaa bbb

table 2

Id ...

Just curious (and this is a serious question - not being a smart @ss here): what in all that stuff you told us, which was a LOT, gives us any...

Timmorehead 14652 (11/2/2016)

---

To shrink it properly, so that it does not grow out of control. Create a Full backup of temp, then create a transaction backup say every 30 minutes...

GilaMonster (11/2/2016)

---

The optimiser knows nothing about fragmentation of indexes, the index's layout or...

You should have compared the original poor queries Estimated Rows with the Actual Rows at various points in the plan. I am guessing you had a 3+ order of magnitude...

Hope your Capacity value never comes in as 0! :hehe:

BOR15K (11/1/2016)

---

TheSQLGuru (11/1/2016)

---

BOR15K (11/1/2016)

---

Sadly you're right - every new customer starts from...

BOR15K (11/1/2016)

---

Sadly you're right - every new customer starts from 2 to...

1) Please post up table defs, sample data (in the form of INSERTS) and expected results to clarify your logic and help us write queries to solve.

2) Your names make...

In 20+ years of consulting on the SQL Server relational engine at all kinds of scale I can count on one hand the number of times it was REALLY OPTIMAL...