I'm not aware of a good, all encompassing SQL Server 2005 tutorial. I'm with Jack. You'll need to hit JumpstartTV, Simple-Talk, and of course, here at SSC, to get the...

Jack Corbett (1/19/2009)

---

Grant Fritchey (1/19/2009)

---

What? Did the copy editors fall down on the job again. Steve, fire that mangy lot and get someone decent in...

What? Did the copy editors fall down on the job again. Steve, fire that mangy lot and get someone decent in here to protect us...

I'm sorry, but I don't understand the structure. What relates one table to another? How would you join table1 to table2 to get the results you want. What does table3...

I don't see why you both couldn't write an article on the same topic. With your different backgrounds, knowledge sets and approaches I'll bet both would offer up unique information....

rferguson (1/18/2009)

---

Hi Grant, the stored procedure already uses the sp_executesql function. What I'm essentially trying to acheive is to create a dynamic SQL statement, but in which the WHERE clause...

office (1/18/2009)

---

Hello -- I'm working with much smaller databases for web-based database applications using SQL Server Express 2005. I've been very pleased with it for the last few years...

Jack Corbett (1/18/2009)

---

I've got a series on Profiler/Trace in process, building from real basic to a little more advanced (server-side traces, etc...). I was waiting on getting a new...

In fact, you'd probably hurt performance with just an index on Event, depending on where the cluster index is on the table (if there's a clustered index) because you're likely...

In addition to the web sites Gail provided (and the storage engine web site from Microsoft is just fantastic), you might want to read through Kalen Delany's book on the...

Steve Jones - Editor (1/18/2009)

---

Sue moved over to PM'ing full time, not really much SQL Server last year. I actually was thinking to send her an email and see how...

Wow! That is good. I must have missed it the first time round. I agree with the herd on this one Steve, you...

Ninja's_RGR'us (1/17/2009)

---

So what?, only 2 people on that thread answered without reading (or understanding) the question.

Since when reading the full question a requirement of posting an answer?

😀

Maybe it's time to...

GilaMonster (1/17/2009)

---

Not a bad question, but does this guy ever read the posts that he's answering?

http://www.sqlservercentral.com/Forums/FindPost638650.aspx

Question was "I didn't start an explicit transaction, I don't have a backup, how do...

It's just because I find COALESCE easier to read. I don't think...