Nevyn (2/2/2015)

---

This was actually sneakily trickier than it first appears, as showing the 0 level doesn't work with the recursion, and taking duplicates out is tough to work in with...

Nevyn (2/2/2015)

---

So you are doing a 6 degrees of Kevin Scotch on the tables?

Also, does a match have to one scotch in common or all the scotches of the...

Hi Lowell,

I tried something similar, and my head ended up bouncing off it. The trick I was hoping to pull off was something like, provide any starting point, get back...

That was one of the first things I did....

Slightly different take, using ChrisM's sample table.

SELECT s.LinkingID, MaxID

FROM #Sample AS s

CROSS APPLY (SELECT TOP 1 [MaxID]

FROM (VALUES(s.ID1),

(s.ID2)...

Perry Whittle (10/20/2014)

---

Mac1986 (7/3/2014)

---

My Database backup is not working in SQL 2014 RTM version. It works fine on SQL Server 2008 R2.

All databases are in Simple recovery model. Not...

Well, it looks like jokers and deuces are wild here.

Jeff Moden (1/16/2015)

---

sqldriver (1/16/2015)

---

Jeff Moden (1/16/2015)

---

sqldriver (1/15/2015)

---

I have several tables with between 1 billion and 2 billion rows in them that I have to generate reports on. Sometimes periods of...

Eirikur Eiriksson (1/15/2015)

---

sqldriver (1/15/2015)

---

Yeah, I just do this and replace the TOP with whatever target number.

USE tempdb

DECLARE @cntr BIGINT = 0;

;WITH T(N) AS (SELECT N FROM (VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL)) AS...

Jeff Moden (1/16/2015)

---

sqldriver (1/15/2015)

---

I have several tables with between 1 billion and 2 billion rows in them that I have to generate reports on. Sometimes periods of inactivity, sometimes periods...

I have several tables with between 1 billion and 2 billion rows in them that I have to generate reports on. Sometimes periods of inactivity, sometimes periods of high activity,...

Everything I've tried has been an extension of stuff I've seen around here. One thing I thought would make a difference is how many levels of CTEs I was stacking...

Yeah, I just do this and replace the TOP with whatever target number.

USE tempdb

DECLARE @cntr BIGINT = 0;

;WITH T(N) AS (SELECT N FROM (VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL)) AS X(N))

,NUMS(N) AS (SELECT...

What is the size set to here?

Siva Ramasamy (1/12/2015)

---

Dear experts,

Thanks for showing interest in my question and sharing your knowledge to help me out.

The total drive size is about 2.5 TB out of which the...