Welcome to SqlAdvice Sign in | Join | Help

May 2005 - Posts

MSDE v SQLE (plus 8 or 5 concurrent operations?)

Posted Tuesday, May 31, 2005 11:19 PM by RepeatableRead
I'm about to do a couple of posts comparing MSDE against SQL Server Express (or, as I like to call it, SQLE). In these posts I'll cover the facts about MSDE -- in an easy to digest form (I have such a hard time keeping the details straight myself -- I'm Read More...
0 Comments
Filed under: ,

Babies, unmerciful cruelty, and ALTER vs DROP and CREATE

Posted Monday, May 30, 2005 11:11 AM by RepeatableRead
One of the intriguing things about newborns is their propensity to attack themselves. After a few weeks their little hands begin to take on a life of their own: flexing, probing, grabbing. Since their stubby little arms are so short, there isn't much Read More...
1 Comments
Filed under: ,

Max Degree of Parallelism

Posted Tuesday, May 24, 2005 5:59 PM by RepeatableRead
In a previous life (actually two previous lives), I was a production DBA. One of the environments that I inherited had some ... issues. There were a number of Clustered SQL Server installations -- oodles of hardware, all churning to keep product inventory, Read More...
1 Comments

'Math' Question

Posted Monday, May 16, 2005 10:07 PM by RepeatableRead
I'm no math junkie, but I am a Geek. My hunch is that any geeks reading this won't be able to withstand answering a simple question; one that I thought up a while ago to help explain the 'value' of NULL to a colleague. So, here goes. What's the answer Read More...
4 Comments
Filed under: ,