13Apr 2009 by Grant Fritchey 4 Comments

Paul Randal’s Database Size Survey

SQL Server, T-SQL
If you have three minutes to spare, swing by Paul Randal's blog and answer his survey questions about the size and distribution of your database. The results are very interesting. I was most interested in the number of respondents to each of the questions.  As each size category switched, fewer and fewer people responded. However, a lot more people responded than I expected. 94 last I looked had databases under 10gb in size, but 42 had databases over 1tb. Yeah, that's only 1/2, but, holy cow, it's 1/2. I wish I had a database to manage that was over 1tb. Back in the 7.0/2000 days I was at a dot com that was getting close. When I left they had 700gb. I understand they got close to 850 before the…
Read More
11Apr 2009 by Grant Fritchey No Comments

SQL Server Execution Plans Published… Again

T-SQL
My first book is finally in print. OK. I know. It sounds funny. But my first book was printed in only a limited print run from Red Gate, most of which they gave away at Tech Ed last year. Then they offered it for free in an electronic form. Very few people got a printed copy. Well, if you were waiting around for the dead tree version, it's here! Thanks again to Tony Davis & Brad McGehee for all the work they did. It just wouldn't have been possible without them.
Read More
08Apr 2009 by Grant Fritchey 15 Comments

PASS Summit 09 Call For Speakers Deadline Extended

PASS
It's now running until Friday April 24th. That's good news if you couldn't get yourself together by this Friday. However, I wonder if they're also extending the time for the committee to make it's decisions? That means extended worry and sweat for those of us who have already submitted abstracts. But, on the other hand, if they haven't extended the committee's deadlines, then that means those guys are going to be working their behinds off to meet the original date (end of May). I also wonder if it means that they're not getting enough abstracts or if the quality of the abstracts has slipped? New this year you can check out the abstracts to see what others have submitted. That makes for some interesting reading, but now I'm wondering if it's…
Read More
07Apr 2009 by Grant Fritchey 3 Comments

SQL Server Standard Article Available

PASS, SQL Server, T-SQL
Unfortunately PASS decided to put the SQL Server Standard to sleep right after I got an article published in it (and no, it wasn't my fault). However, PASS, being the service oriented organization that they are, has decided to make back issues of the magazine available online. So, to read the article I wrote comparing various methods of retrieving versioned data using different TSQL constructs, click this link. Go to page 14. Oh yeah, and you can see other peoples articles here too. There are other things coming out of the editorial committee soon (although I need to get one of them done myself... yikes).
Read More
07Apr 2009 by Grant Fritchey 6 Comments

NULL Is Not NULL

SQL Server, T-SQL
NULL as a concept seems so easy but it leads to so many problems for people. To put it as simply as possible, NULL does not equal anything. It does not "not equal" anything either. It can't be compared to other values in any way. There was a recent post over at SQL Server Central where the user had a query problem that one of the great people over at SSC solved, handily. They also pointed out that the bit of code being used "WHERE nt.NullableString NOT LIKE 'null%'" was also a problem. The user insisted that it was eliminating the NULL values. Well, yeah, sort of, it was, but not because it was actually applying a filter to the NULLs. Remember, a NULL does not equal or "not equal"…
Read More
30Mar 2009 by Grant Fritchey 4 Comments

Reading to Learn

Spatial Data
I just finished chapter 1 of Alastair Aitchison'snew book on SQL Server spatial data, "Beginning Spatial with SQL Server 2008." If this is the beginners book... oh boy. The advanced book must be insane. Seriously though, Mr. Aitchison seems to have written a fantastic book. I'm going to tear through it as fast as I can because I've got two projects that are looking to start using spatial data and quite frankly, I'm a bit lost. There's a great discussiongoing on over at SSC as to the worth of technical books for DBA's. It's based on this editorialby Tony Davis. I'm surprised by the number of people who say they don't use books. It seems that a lot more people use blogs and articles and discussion groups to learn. Maybe…
Read More
27Mar 2009 by Grant Fritchey 5 Comments

Connect Works

Uncategorized
Microsoft Connect works. I've said it before and I'll say it again, but it really does work. You will get the attention of MS developers and they will respond. It's not always fast, but it gets there. Of course, I was trying to create samples for the book, which came out almost two weeks ago, so this is a bit late for me personally... HA! But it really does work.
Read More