|
|
|
|
Browse by Tags
All Tags » Tips (RSS)
-
A lot of people sent me emails asking for a way to get ahold of Quest Software's new DMV poster. The poster shows all of the major DMVs in SQL Server 2005/2008, what they're used for, and how to query them. You can get the poster (for free, of course) Read More...
|
-
While I'm recovering from surgery, I've been thinking about what makes a technology poster worth putting up on your wall? As I walked around TechEd last week, there was no shortage of posters available for all sorts of technologies. Some were mostly diagrams Read More...
|
-
I find that auto_update statistics in SQL Server is a really good thing. Without it, many third-party applications would simply fall over from lack of preventative maintenance. W ith it, they are able to run for extraordinarily long periods of time without Read More...
|
-
One of the best things about becoming a Microsoft MVP is meeting other MVPs. I bring this up because last week was the annual MVP Summit in Seattle, WA. I was really looking forward to meeting Steve Kass . Steve Kass is one of the smartest SQL Server Read More...
|
-
You'd think an article called "NASTY RUMORS ABOUT MAXDOP" would have something to do with Britney Spears or maybe Robert Downy Jr, but in that case it'd be total fiction (at least, it would be coming from my pen). So, I was en route to the 2008 Microsoft Read More...
|
-
Kevin gives a run-down of the dozens of SQL Server topics (and other topics) he's been trying to stay on top of. Read More...
|
-
I was recently trying to diagnose some problems in one of my SQL Servers when I ran across a problem that I hadn't encountered before involving 'nonyielding worker threads'. SQL Server also produced a dump for me to review. Unfortunately, the dump didn't Read More...
|
-
Ever have a situation where you’d like to know what TCP/IP ports are open on your server? Read More...
|
-
MVP Hugo Kornelius once reported that he encountered a situation in which it was possible to perform a table scan on more pages than actually existed in the heap table. Hugo deduced that this was due to a phenomenon called “forwarding pointers”. Why in Read More...
|
-
Aaron Bertrand, a blogger on SQLBlog.com and keeper of www.aspfaq.com is one of those SQL Server MVPs whose material is always on my must-read list. Here's a really useful query he developed to determine the space used by objects in TempDB: SELECT SPID Read More...
|
-
You might have noticed, if you’re a heavy user of PerfMon, that some counters are exhibiting alterations in behavior between SQL Server 2000 and SQL Server 2005. For example, I’ve long used the “Transactions/sec” counter to get an idea of how much work Read More...
|
-
If you use computed columns a lot, you might want to know about some new behavior in SQL Server 2005. Read More...
|
-
Have you ever made a New Year's Resolution to drop a bad habit, maybe to stop snacking on junk food or to stop biting your nails? Have you every made a similar resolution to pick up a good habit - flossing anyone? They're both hard to make stick. For Read More...
|
-
I'm on my way to the PASS Summit, but thought you might enjoy reading some of these cool articles. If you're going to the PASS Summit, drop me an email and perhaps we can meet in person! -Kevin ETL Performance: Unisys and Microsoft SQL Server 2005 Speed Read More...
|
-
Italian SQL Server MVP Davide Mauri has released four very useful scripts that simplify the usage of SQL Server 2005 DMVs to discover, analyze, and understand index usage and health. The queries are not rocket science, but they are long and rely on DMVs Read More...
|
|
|
|
|
|