Archives: March 2011
In February I posted this post about the need for Volunteers for SUMMIT 2011. I submitted my application to volunteer. This past week I got word back concerning that application. I am pretty happy that I have the opportunity once again to serve on a subcommittee for the upcoming SUMMIT. Read more
Do you use NULLIF? For me, this command has been seldom used. Because of that, I have been dabbling with it a bit lately to make sure I have a better understanding of it.
What is it?
This is a function that compares two values. If the two values are… Read more
Do you ever find yourself working on different scripts at once? Maybe you are working on something that tests certain functionality in SQL Server, you have some presentation scripts you are working on, and possibly three or four scripts related to a project at work. I find myself in a… Read more
I just ran into something that I hadn’t noticed in SQL Server. It struck me as somewhat interesting but is really not too big of a deal.
While demonstrating that the XML plan can be generated when you dump data into a temp table, I happened onto this little ditty.… Read more
I was asked a few months ago to allow some advertising on my blog. I hadn’t given the idea a whole lot of thought but was reminded again today about the request. For now, I think I will just give the requester a mention and add the tool he wants… Read more
From time to time I see a question asking how to determine the last time a SQL Server was either restarted or when the last time was that the database was used. For the first question there is a pretty common answer that works for SQL 2000 and up. In… Read more
By now, I am sure that you are well aware of the Resource Database. Starting with SQL Server 2005, a new system database was made available – the Resource Database. In SQL 2005 you could move the Resource Database – but in 2008 and beyond you cannot. If you plan… Read more
As a DBA working with SQL Server, some data issues arise that need to be fixed. One such data issue is the duplication of data. Duplicate data can happen for a number of reasons. One such reason is the absence of constraints such as Primary Keys.
Luckily, there are ways… Read more
After posting a database tools list yesterday, I found that there were things that I had forgotten and a couple of things that i hadn’t even considered. In thinking about this, I found myself trying to find a script that I knew I had seen and that I wanted to… Read more
Recently I have posted a couple of articles about various database or SQL tools either for maintenance or for benchmarking. Those posts work well in conjunction with a post several months back that you can read here. These posts made me think a bit harder about the tools… Read more
In SQL Server, there is a good set of preloaded reports to help you monitor the Instance. These reports can be found under the Standard Reports and can be reached via context menu. To find them, right click your Instance in Object Explorer from within SSMS. Then navigate the context… Read more
The Las Vegas SQL Server Users Group met on March 10, 2011. The meeting was both virtual and in-person. Good news – we had just about as many person attending online as we did in the meeting room.
As database professionals, we have a need to benchmark performance of the database, processes, and essentially overall performance. When benchmarking, it is preferable to get a baseline and then run the same benchmark tests on a periodic basis and compare those results to the baseline.
Recently I was reminded of… Read more
How many DB professionals have never had to deal with bitwise operations in SQL Server? Who has never had a single value in the database represent more than one data value? Have you ever had one of these fields serve as the(implicit or explicit) foreign key to a source table? Read more
I often see a request for some scripts to help with database maintenance. Sometimes those questions come in the form of recommendation requests for maintenance plans. As many already know, there are some really good recommended scripts by Ola Hallengren. There is also the fantastic index defrag script by Michelle… Read more
Data Size Collection and Analysis
By now you should be well acquainted with this phenomenon we call TSQL Tuesday. This party is being hosted this month by Jes Schultz Borland (Twitter | Blog). She has challenged us to write something about aggregations and aggregation functions in SQL Server. Read more
This is just a quick reminder about the meeting coming up on March 10, 2011 at 6:30 PST. You can find more information about the event from here.
I am looking forward to this presentation. I think this presentation can be highly useful for both Production DBA as well… Read more
In early January, I wrote a little tribute to my wife for the awesome job she does when making cakes. There was a lot of good feedback from that. You can go back and read it from here, if you like. This is a short follow-up to that article.… Read more
Last Year I introduced a couple of scripts that I worked on. Those scripts developed into a series covering the comparison of some methods and MS provided stored procs that could help you in the retrieval of table sizes in SQL Server.
I pulled out one of those scripts recently… Read more
The Ides of March are upon us and that means that we have another opportunity to learn some stuff about SQL Server. We have that opportunity because it is time for the monthly S3OLV User Group meeting.
This month, Glenn Berry of SQL Server MVP fame has volunteered to present… Read more