Impossible to say without knowing the business. I have a friend who owns a small (2 employees) side business who was looking at moving all his paper records to...

Certification exams for SQL Server 2005 were just retired this year. I would think you would have at least another 3+ years before the 2008 exams get retired. ...

Nick - Check out this blog post by Jonathan Kehayias. Should give you what you're looking for?

http://www.sqlskills.com/blogs/jonathan/post/Finding-what-queries-in-the-plan-cache-use-a-specific-index.aspx

Same as above. I usually keep a couple days worth.

Sean Lange (12/5/2011)

---

bwoulfe (12/5/2011)

---

Sean Lange (12/5/2011)

---

I guess the way you store your date information will be somewhat dependent on how you are using it. Personally I like to store everything...

Sean Lange (12/5/2011)

---

I guess the way you store your date information will be somewhat dependent on how you are using it. Personally I like to store everything in UTC along...

I can't answer your question for you and without looking it up I'd just be taking a best guess. What I can tell you though is DBCC DBREINDEX is...

Yeah, I saw that but I wasn't completely sure what you meant. Should have asked. Thanks again for the help!

Yeah possibly. In any event I finished that query and it's working great so thanks for that. I now haven't a different query that with slightly different xml...

Thanks Drew, that gives me what I need. Could have sworn I tried something similar to that but it bombed out. I probably had one of the paths...

Sean Lange (11/10/2011)

---

And if at all possible a little normalization would go a LONG way to making your life a lot easier. You need to spin off off several detail...

John, nice article. For the next one if you could show us a way to predict future stock moves that would be great. 😛

It's a very good book especially if you are new to sql. I was introduced to sql about 6 or 7 years ago so most of the material was...

Can you pass in an xml data type? The xml could look something like this: <root><row name="name1" class="class1"></row><row name="name2" class="class2"></row></root>

And then you'd write your stored procedure to look something...

How funny, I randomly run into this thread and I had the same exact problem last Friday. Running the BULK INSERT command that pointed to a file on the...