Welcome to SqlAdvice Sign in | Join | Help

Browse by Tags

All Tags » Theory vs Reality   (RSS)

Microsoft's direction with SQL Server Tools

Posted Thursday, November 08, 2007 9:42 PM by michael.k.campbell
I'm with Stephen Wynkoop on this one - I'm not sure I'm too hip on Microsoft's emerging direction to divide SQL Server Tools into Developer and Admin Roles. Stephen just posted an editorial based on an interview that he had with Matt Nunn, and points Read More...
0 Comments
Filed under: ,

Micro Indexing

Posted Thursday, January 25, 2007 12:12 PM by michael.k.campbell
It's almost a rule of thumb to avoid indexing strategies on tables with less than a few thousand rows. The reason, of course, is that SQL Server will frequently just ignore indexes on 'tiny' tables - preferring instead to perform table scans. However, Read More...
0 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: ,

Camping and Problem Management

Posted Wednesday, February 16, 2005 12:41 PM by RepeatableRead
Camping presents a unique insight into problem management, and can also present a powerful metaphor about how people solve problems. If you've done much real camping, i.e. out in a semi-wilderness area as opposed to being in a groomed state-run/private Read More...
9 Comments

Theory vs. Reality

Posted Monday, May 03, 2004 9:50 PM by RepeatableRead
Will theory and reality combine to form a flavor-of-the-month? Will reality triumph? Then what point theory? Read More...
3 Comments
Filed under: