Search Results | SQL Server Performance Forums

autogrow question

Thread by: rklimes, Jul 2, 2008, 10 replies, in forum: General DBA Questions

I have a database which has autogrow turned on and is set to grow 10%. My database was 228GB. my database grew last night to a size of 270GB. This...

Conditional Union

Thread by: rklimes, Apr 28, 2008, 5 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

I was wondering if there is a way to have the result of a case statement be a t-sql statement within a union? If not, is there another way to...

Security on read-only database

Thread by: rklimes, Feb 8, 2008, 9 replies, in forum: General DBA Questions

I have a log shipped database that is in read-only mode. I wanted to add a new login to be able to access this database but since it is read-only...

Long running delete

Thread by: rklimes, Feb 6, 2008, 7 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

I had tried to run a delete on a table base on rows in another for archiving but the statement ran for over 3 hours and eventually failed because...

need query plan explination

Thread by: rklimes, Dec 21, 2007, 8 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

I have a fairly basic query and am confused as to why an index is not being used. The query does an index scan the primary key (clustered) index but...

Change Tempdb initial size

Thread by: rklimes, Oct 21, 2007, 13 replies, in forum: General DBA Questions

I would like to lower the initial size of tempdb. I have tried running USE master GO ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, SIZE...

linked-server error

Thread by: rklimes, Aug 29, 2007, 2 replies, in forum: SQL Server 2005 General DBA Questions

I am trying to update a table in sql server 2000 based on values in a 2005 database. I can insert successfully but when I try to update I receive...

CTE within a CTE

Thread by: rklimes, Aug 14, 2007, 7 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Is it possible to have a CTE within a CTE? or would I have to have a derived table within a CTE expression? have provided simple example. WITH...

help tuning query, incorrect index usage

Thread by: rklimes, Jul 10, 2007, 6 replies, in forum: T-SQL Performance Tuning for Developers

I have a poorly performing view that consists on 3 union-ed sql statement. one of them takes approx 5 min to return results. The execution plan shows...

DTC with clustered SQL servers

Thread by: rklimes, May 31, 2007, 5 replies, in forum: SQL Server 2005 General DBA Questions

I have an odd situation occuring. I have two clustered instances of SQL server ( one is 2000 enterprise and 2005 enterprise, both are running on...

execution plan differences

Thread by: rklimes, May 17, 2007, 5 replies, in forum: T-SQL Performance Tuning for Developers

I have a very basic query that creates different execution plans in production and test environments. Both environments have similar amount of data...

MAX in where clause

Thread by: rklimes, Apr 9, 2007, 2 replies, in forum: T-SQL Performance Tuning for Developers

What is the best way to have MAX (or any aggregate function) in where clause? I am using the query below but performance is really bad. I would...

SP1 failing on cluster

Thread by: rklimes, Nov 24, 2006, 11 replies, in forum: SQL Server 2005 Clustering

I am attempting to install Service pack 1 for SQL server 2005 on an active/passive cluster but it is failing while trying to patch the passive node....

Log Shipping Monitor not updating

Thread by: rklimes, Sep 18, 2006, 2 replies, in forum: SQL Server Log Shipping

I have recently setup log shipping and everything looks to be working correctly except my secondary database is not updating the monitor server. I...