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 […]
Tools note
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 […]
SQL Server Startup
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 […]
SQL Resource
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 […]
Dedupe Data CTE
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 […]