I recently received the following email from a blog reader:
"We are having an OLTP database instance, using SQL Server 2005 with little to moderate traffic (10-20 requests/min). There are also bulk imports that occur at regular intervals in this DB and the import duration ranges between 10secs to 1 min, depending on the data size.
Read more →
Paul Randal recently blogged about three life-changing events that brought him to where he is today. His blog is a very interesting read and idea, and so I bring to you my three events that brought me to where I am today in my technical career as a SQL Server DBA.
Read more →
I have modified isp_Backup, which is the stored procedure that I use to backup SQL Server 2005 and 2008 databases. This new version includes one new feature, which I think is critical to SQL instances with multiple databases on them.
Read more →
A few weeks ago, we were preparing to move our SQL Server 2005 databases from a 4-node Windows 2003 cluster to three 2-node Windows 2008 clusters. On the new clusters, we noticed that Database Mail and the monitoring application for Database Mirroring weren’t working on four of the SQL Server 2005 instances that we had installed.
Read more →
You can only have one clustered index on each SQL Server table, however there are two ways to create pseudo clustered indexes on a table:
Create clustered indexed on a view (indexed view) that covers the table Create covering index on the entire table Let's look at the following table:
Read more →
I have modified isp_ALTER_INDEX, which is the stored procedure that I wrote and use to defragment/rebuild indexes in SQL Server 2005 and SQL Server 2008. The code change has just one bug fix.
Read more →
My Database Growth Tracker tool is featured in a SQL Server Magazine web article that Kevin Kline wrote.
Check out the web article here!
Legacy Comments
Brett
2009-10-09
re: SQL Server Magazine web article about a tool I wrote Wow.
Read more →
After attaching or restoring a database to SQL Server 2005, you may encounter an error when executing a CLR object. Error:
An error occurred in the Microsoft .NET Framework while trying to load assembly id 65538.
Read more →
The SQLCAT team released a very informative whitepaper regarding backup and recovery of very large databases in SQL Server 2008. It is a must read if you are a SQL Server DBA.
Read more →
I have modified isp_Backup, which is the stored procedure that I use to backup SQL Server databases. This new version includes one bug fix and three new features:
Bug Fix – removed ReportServerTempdb from exclusion list Bug Fix – fixed file retention code to handle database names with spaces Feature – support for SQL Server 2008 including compression Feature – archive bit option Feature – COPY_ONLY option I decided that excluding the ReportServerTempdb from the backups was unnecessary.
Read more →
For various reasons, you may need to manually remove SQL Server replication. Microsoft has a good KB article which shows how to do it. It has always worked in the past, but I ran into a situation a couple of weeks ago where it couldn’t remove the distributor via sp_dropdistributor.
Read more →
I have modified isp_ALTER_INDEX, which is the stored procedure that I use to defragment/rebuild indexes in SQL Server 2005 and 2008. The new version has a minor bug fix. Recently I was comparing the fragmentation results between the DETAILED and SAMPLED modes of sys.
Read more →
UPDATE: A new version of this stored procedure is available. Please check it out here.
I have modified isp_ALTER_INDEX, which is the stored procedure that I use to defragment/rebuild indexes in SQL Server 2005.
Read more →
I was going through my scripts today and found one that I’d like to share. This SQL Server script will display job history. The benefit of this script over displaying it from the GUI is that you get to see the job durations quickly.
Read more →
EDIT: new version of stored procedure is located here. Use the new version for 2005/2008. Use the below version for 2000.
I have modified isp_Backup, which is the stored procedure that I use to backup SQL Server databases.
Read more →
UPDATE: This stored procedure has been updated.
I have modified isp_ALTER_INDEX, which is the stored procedure that I use to defragment indexes in SQL Server 2005. The changes include one bug fix and one feature request.
Read more →
If you've ever had to copy large files on a Windows platform using the Windows copy method (copy/paste in Windows Explorer or copy/xcopy commands), then you know how slow it is.
Read more →
Microsoft published the ERD for the system views about a month ago, but I'm just now seeing it. It is available in PDF or XPS format.
You can download them here.
Read more →
As a DBA, we are often asked to refresh a database, which means to overwrite an existing database using a different database's backup. If you are rarely asked to do this, you may decide to do it manually.
Read more →
This is very amusing and sad, and it is a great example of why backups are so important.
Now the company is dead thanks to their malicious IT guy.
Read more →