Steve Jones - Editor (8/12/2009)

---

Nope, nor does...

Steve Jones - Editor (8/12/2009)

---

Barry,

That's actually a pretty good suggestion, though I'm not sure how easy that is to set up. I'll have to see if we can creatively try...

I'm going to go out on limb here, but the problem isn't your query. It is the amount of data you are trying to pull down to you desktop...

Look at the sample code in BOL under Recursive CTE's. You can access BOL from SSMS by pressing the {f1} function key.

You can also check out this post as...

How big is each row (in bytes)? What type of network are you on 10MB/100MB/1000MB? Are connected to the network via a switch or hub?

mish (8/12/2009)

---

I have done the questions and it was just question 4 I had problems with. I have just been told that SQL server does not have the LIMIT so...

john.arnott (8/12/2009)

---

And laugh even harder again at the response to...

Laugh I did at the image of Qui-gon and Yoda, both with light-sabres ready, asking Is this homework?

Tim Walker (8/12/2009)

---

Steve Jones - Editor (8/12/2009)

---

The disclaimer is another idea that we can look at. I'm not sure quite how to word it, and my guess is that we'll...

Think I do that school work this is, right?

For routine work, neither Developers or DBAs actually need sysadmin rights to production databases. That is how mistakes happen that can be avoided. Developers shouldn't even have db_owner...

Hah! Looks like a Rookie used the Force on the Mighty Gila! 😉

I didn't forget, I just spent most of last night figuring out a problem I was having here at work. Hopefully tonight I may get some time to look...

steve_melchert (8/12/2009)

---

I'm not sure what jobs y'all have that allow writing these 1,000 word posts. I've spent more time on this board in the last couple of days than...

You can't restore a SQL Server 2008 backup to SQL Server 2005. If you need to move/deploy a database from SQL Server 2008 to SQL Server 2005, you need...