Software is typically built upon a platform, and therefore what the software supports is determined by what the platform supports. If the software has to go beyond this boundary and...

Good question, and easy if one has ever experienced orphaned transactions. Even in the Books-On-Line, this one is hard to find (there's just one reference to the -2 value).

Overall, a...

This is a good article, and an even better mnemonic - thanks for sharing!

I lead a team of about 5 people, and encourage external reading as well - both technical (i.e. related to IT) as well as nontechnical (could be core sciences, management,...

Right-on! Thank-you for sharing the original post, Steve! In my 6 years of experience, I have done numerous production ad-hoc updates, but have always ensured that all 7 processes are...

Good to see this strip in today's newsletter! I am not sure whether we will have new ones or not, but request you to keep scheduling reprints of the older...

Thank-you for the article. It was a good read (sounded more like a blog post though). The readers got some good tips out of it, but what remains is a...

Schodoodles (5/6/2011)

---

SQL Server is already used by F1 teams (McLaren mainly but now all it seems) for live data recording and processing on the fly. Sure I saw an article...

Here in India, we have a saying that if a restauranter does not eat in his/her own restaurant or if a building contractor does not live in buildings they built,...

Great question! Something every administrator needs to think about. Thank-you, and have a great week-end ahead.

You may want to take a look at my article - http://www.sqlservercentral.com/articles/T-SQL/72606/%5B/url%5D - which was recently published by SSC.

In this post, I look at one of the strategies that we...

Definitely expecting more 🙂 Maybe...

No, all 4 do not work correctly...

Thank-you, Duncan for this wonderful series!

If the disk somehow fills up completely and the SQL Server is not able to allocate more space, an error 1101 or 1105 will be raised (and logged). The database...