You simply MUST NOT order all rows to get one!! That is an immensely costly operation!

One quick-and-easy way is to get min and max ID values and create a WHILE...

1) Is this a virtual machine?

2) Do you have anti-virus running on it?

3) You could set up a profile trace to local disk to capture queries with large amounts of...

webrunner (12/4/2015)

---

Hello experts,

Does anyone have any suggestions or references for how I can use ETL concepts for a data feed, as opposed to a data warehouse? A lot of the...

I am 99% confident that there is a TIME element in the date fields that is messing things up. Assuming you don't CARE about the time, you have two options:...

The simplest solution by far would seem to be fix the data. 🙂 Update all NULL start-date values to the minimum for the data type (1/1/1753 for full datetime for...

Jeff Moden (12/3/2015)

---

Aditya Daruka (12/3/2015)

---

It may be slower, but still quite an interesting way of playing with t-sql

Everything is not always about speed!

I am happy with tally function, great way...

Oh, duh! The event's table is the one that has ALL the rows that are needed. I think Chris has it.

What happens to the output if you remove the datediff and just show the min date instead?

I don't understand what the bigints have to do with it. For a real or virtual table of numbers that goes from 1-N:

select startnum + (num-1)

from numtable

where num <= rangevalue

I was going to suggest Express Edition too if db sizes allow. If not, then you are probably into Standard Edition and per-core licensing, so then it becomes a matter...

Johnny B (11/23/2015)

---

Hi,

We are a team of 6 DBA's for a government district servicing 6 vendor applications. Our servers are virtualized and consist of 2008 R2 and one legacy SQL...

How can we help you with so little information? No code for the stored procedure, no code actually doing the blocking, object that is blocked, other code requesting the lock...

You cannot time the restores based on no current connections to the database because in the finite time between determining no connections and getting the restore job kicked off any...

Eric Mamet (8/27/2015)

---

I must admit I came across CDC before and it might be a viable option too.

I don't have any experience of it though...

Has it got a reputation...

Robert W Marda (8/26/2015)

---

I guess it would have helped if I had explained better.

The deadlocks I see the most often are with two SPIDS having a page lock on...