The Multifunctioning DBA:

SQL Server 2008

1

July 29, 2010  5:00 PM

SQL Query Troubleshooting



Posted by: Colin Smith
DMV, Performance Tuning, SQL Server 2008

So I am by no means good at wtiting T-SQL or optimizing the code. But, Yesterday one of our devs called me and said that he had a SSIS job that was running i about 45 minutes start taking 10 hours. Ouch that can not be good I said. I asked him what tables were involved and I opened up my...

October 27, 2009  3:30 AM

Active, Active, Active



Posted by: Colin Smith
Cluster, MSSQL, MSSQL Administration, MSSQL Install, MSSQL Server, SQL Server 2008

Last week I got the chance to work on an Active, Active, Active SQL Server 2008 Cluster install. This was new to me and very fun. We have three physical hosts all using SQL Server 2008 Enterprise Edition. The Servers are also running Windows Server 2008 Enterprise Edition. I worked with one of our...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: