|
|
Browse by Tags
All Tags » SQL Server 2005 (RSS)
-
Way back in June 2005, I blogged about ' 8 Steps to better transaction log throughput '. I did this blog post after seeing (again and again) overly fragmented transaction logs... Transaction logs can become *VERY* fragmented when they are not Read More...
|
-
Well... I think I had had too much tea that morning ;-). But, as always, chatting with Richard and Greg was great. Here's the specific show link: http://www.runasradio.com/default.aspx?showNum=76 . Oh, and just for the record, I didn't come up with that Read More...
|
-
I first posted an update to sp_helpindex here . My version of sp_helpindex was solely to expand what sp_helpindex showed and adds 1 or 2 things based on version: for SQL2005+ it adds included columns and for SQL2008 it also adds the filter predicate. Read More...
|
-
YES!!! OK, well, I guess I should be more specific because as in most things in SQL Server, the real answer is "it depends". And for these two options, it depends mostly on your SQL Server version. Since SQL Server 7.0, the way that auto update works, Read More...
|
-
Microsoft quietly released CU #9 (build 9.00.3282) yesterday; it contains a few dozen fixes, including a nasty AV involving UNION queries, documented in KB #956006 . You can read about / obtain the cumulative update at the following KB: http://support.microsoft.com/kb/953752 Read More...
|
-
I am pleased to announce that the BIDS Helper team have just released v1.3 which is our first release with support for SQL Server 2008. With these release we have also improved our international support. All of the features in BIDS Helper still only display Read More...
|
-
OK, I first posted on some of the limitations to indexes in SQL Server 2005 and 2008 in part one here . Now, I want to dive into index internals for a post (or two). And, I often get the question “ who is the best audience for your blog – or, for this Read More...
|
-
Memorial Day weekend we were in Chicago to celebrate my Father's life. We did a "Celebration of Life" memorial and we had a few drinks (celebratory Meyers, Tonic and lime - which was my Father's favorite drink), we (7 of us) gave a few heartfelt speeches, Read More...
|
-
A frequently asked question that surfaced again today is, "how do I see when my data has been accessed last?" SQL Server does not track this information for you. SELECT triggers still do not exist. Third party tools are expensive and can incur unexpected Read More...
|
-
OK, we were in Iceland and then Florida for our Accidental DBA workshops and both went really well. People agree that there are quite a few involuntary/accidental DBAs out there and overall, we helped quite a few to see a lot of options for better performance, Read More...
|
-
Bob Ward posted a blog entry today where he explains the process of getting a cumulative update for SQL Server without having to call Microsoft's support team (they are called CSS now but you may remember them as PSS). This is a great evolution in the Read More...
|
-
In my blog post on my new sp_helpindex proc ( sp_helpindex2 ), I mentioned that the indexes in my sample were not necessarily a recommended set of indexes - just a test set of indexes. So... in this post, I thought I'd start a series on indexes, limitations Read More...
|
-
OK - so this has been frustrating me for many months... when you create indexes with included columns (which was a new feature of SQL Server 2005), they're not shown by sp_helpindex or by DBCC SHOW_STATISTICS. I understand this not showing for statistics Read More...
|
-
OK, I still have a way to go in learning about data compression in SQL Server 2008 but one thing that I do know is that nothing is free. So, the trade-off will be performance (i.e. CPU) v. space. And, that's not really a new trade-off wrt to compression. Read More...
|
-
OK, have you ever been working on one thing...that led you to another ( and another and another ) and then you seem to have lost hours? OK, I know. That's our life [in the computer industry and I'm sure others!] - putting out fires and chasing strange Read More...
|
|
|
|