Joe Webb

Musing and observations about SQL Server, other technogies, and sometimes just life in general
posts - 85, comments - 857, trackbacks - 0

My Links

News

This blog has moved!

Click here for the new location.

Follow me on Twitter
Add to Technorati Favorites

Search this Blog
 




Archives

Post Categories

About me

June 2008 Blog Posts

Finding IDENTITY columns

As database administrators and developers, it's our job to know the in's and out's of the data in our charge. Whether we're designing entity relationships to support underlying business requirements, optimizing indexes to achieve the best response times, or writing a query to retrieve the right data in the most efficient manner, having an intimate knowledge of the database is key. However, since few of us are responsible for just one database, it's sometimes difficult to gain, much less maintain, that level of familiarity with our data. Fortunately for us, however, we have the metadata available to us. We can use...

posted @ Friday, June 27, 2008 8:57 AM | Feedback (11) | Filed Under [ T-SQL ]

Working with tempdb

I was searching for something online the other day and stumbled upon this TechNet article - Working with tempdb in SQL Server 2005. It's a good little article and I wanted to share it with you. Enjoy! Joe

posted @ Thursday, June 19, 2008 6:11 AM | Feedback (3) | Filed Under [ SQL Server ]

Powered by:
Powered By Subtext Powered By ASP.NET