SQL

Deleting millions of rows from SQL

Posted on

Occasionally you can end up with very large databases that you need to purge old data from. Unfortunatly you cant delete all the old data in 1 chunk since it will cause you SQL server to stop serviceing anything else (and potentially fill up your logs). Below is a little script I used to delete […]

SQL

Reporting on space used in a SQL database

Posted on

I had the need today to look at a database and quickly identify which tables were taking up the most space. Since there are over 400 tables, doing this by hand wasn’t going to work. Below is the TSQL script I created based on the sp_spaceused stored procedure to catalog the data and output it […]

SQL

Creating a bell curve in excel – VMware

Posted on

In reviewing the VMware performance data in my cluster, I wanted to identify what the average utilization was. Specifically, I wanted to know what the average MHz per Proc utilization was. The goal eventually being to put limits on the CPUs (x MHz per proc) and if you need more speed, then you buy more […]

SQL

SSRS Format codes

Posted on

If you use SQL Server Reporting Services (SSRS), then you have probably used the “Format Code” setting when desiging a report. But what codes are available, and where can you find a list of them? Below is a list of what I have been able to find, it may not be complete, but its a […]

SCOM

Using SCOM to monitor SQL Error Logs

Posted on

Our SQL DBA reported that occasionally he will see errors in the SQL Error Logs similar to: SQL Server has encountered 45 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [T:MSSQLDatatempdev6_Data.NDF] in database [tempdb] (2). The OS file handle is 0x000005B4. The offset of the latest long IO is: 0x0000000c7b2000 […]

SQL

Report Server log file growing nonstop

Posted on

Last friday I was alerted to the log drive filling up on a SQL 2005 server. I looked into it and found that my SQL Report Services log file (ReportServer_Log.LDF) was increasing in size and filling up the drive.My first thought was to simply shrink the file via SQL Server Management Studio – select the […]

SCOM

Migrating SQL servers

Posted on

In the process of our SCOM rollout we used a temporary server for our SQL databases. Finally the new hardware came in, but now we have to migrate the databases with minimal downtime. This is compounded by the fact that the new server is 64bit OS and SQL, where the original was 32bit. For posterity, […]

3GB

File copy failures across WAN links

Posted on

We have a customer that is trying to copy data from his JDEdwards enterprise server (NT SQL) across the extranet and it fails intermittently. After researchign the issue, the customer suggested that the issue has been occuring for a while and always seems to happen during times of high load (payroll processing, etc…). The file […]