Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: November 2009

Table and Index Partitioning Demo

I get a lot of requests for explanations about the different concepts and the easiest way to demo partitioning in SQL Server 2008. So in the spirit of education I have adapted the demo from the new features white paper from Microsoft, added explanations and guidance as to how to…

Read more

0 comments, 109 reads

Posted in Adam Jorgensen on 3 November 2009

Smooth Compound Operators

Ok, so I can’t promise you’ll be smooth by the end of this entry, but I can promise you’ll be compound operating like a champ. In SQL 2008 there is a new feature called .. you guessed it … Compound Operator. What Microsoft means by this is they have implemented…

Read more

0 comments, 75 reads

Posted in Adam Jorgensen on 3 November 2009

Kick xp_sendmail to the curb

With the advent of SQL Server 2005 and 2008, mail in the database engine has changed dramatically. Previously you had several options for working with email in the database. You could use any of the following procedures:

 

XP_SENDMAIL – Click here for details on this procedure

XP_READMAIL– Click here for…

Read more

0 comments, 288 reads

Posted in Adam Jorgensen on 3 November 2009

Week of Warehousing - Questions Answered

Greg emailed me a great question from my week of warehousing webinar the other day. We were discussing disk performance and kept saying the term “spindles”as in using more of them to increase performance and throughput. The term means an individual hard drive in array. Many large disk systems have…

Read more

0 comments, 79 reads

Posted in Adam Jorgensen on 3 November 2009

Check out Straight to 8 Program

We seem to be busting at the seams lately with quality content from great providers. I wanted to recommend to you a great series of webinars that is being delivered by Microsoft. They cover all the reasons you should examine SQL Server 2008 as your next generation relational and intelligence… Read more

0 comments, 76 reads

Posted in Adam Jorgensen on 3 November 2009

Week of Warehousing Review

How exciting was last week! Some of the top experts in the country all gathered together through support from SQLServerCentral.com, Wrox and Wiley Press and of course, us here at Pragmatic Works. The week went well and I want to point you to a few links where you can watch…

Read more

0 comments, 71 reads

Posted in Adam Jorgensen on 3 November 2009

The Enduring DBA

We are all facing the challenges of this new economy. There are very few people and industries in the world today that have been unaffected by the failures and poor management of some of our largest institutions. I would like to discuss an alarming trend that I have seen in…

Read more

0 comments, 71 reads

Posted in Adam Jorgensen on 3 November 2009

Newer posts