Search Results | SQL Server Performance Forums

Cleaning up Extent Scan Fragmentation

Thread by: druer, Mar 30, 2007, 1 replies, in forum: Performance Tuning for DBAs

I came across a weird situation that others may or may not have already done for a long time and may say "well obviously" but I figured I would share...

EMC vs NETAPP SAN

Thread by: druer, Oct 23, 2006, 5 replies, in forum: Performance Tuning for Hardware Configurations

Does anyone have any strong opinions regarding an EMC CX3-20 vs NetApp FAS270 SAN solution? Does anyone have any strong opinions regarding the...

Join between 2 tables with multiple values needed

Thread by: druer, Jun 9, 2006, 6 replies, in forum: T-SQL Performance Tuning for Developers

I have an appointment scheduling system (I've sort of inherited) that has columns for a typical scheduler where there are time slots and the resource...

Removing a LOG file

Thread by: druer, Feb 10, 2006, 2 replies, in forum: General DBA Questions

I seem to have put myself into a corner and need to know if there is a way around it. A second drive array was added recently to a server. I recently...

Indexes on Secondary Filegroup

Thread by: druer, Jan 16, 2006, 8 replies, in forum: General DBA Questions

I haven't come across anything which would tell me for certain what would happen if I move some of my hardest hit (non-clustered) indexes to a...

SQL Profiler and Filtering

Thread by: druer, Dec 14, 2005, 5 replies, in forum: Performance Tuning for DBAs

Is it just my luck that nearly 90% of the time I try to filter for data in SQL Profiler the trace ignores my filter criteria or do others have the...

How do I login using SQL Server Management Console

Thread by: druer, Dec 2, 2005, 2 replies, in forum: SQL Server 2005 General Developer Questions

I just installed the SQL Server 2005 Standard Edition which I got for free at the Launch event. During installation I wasn't prompted for any SA...

Capturing Blocking Processes

Thread by: druer, Nov 9, 2005, 0 replies, in forum: Contribute Your SQL Server Scripts

Long ago I create a script that ran every minute and would email me if there were processes that were being blocked on the server. After a while of...