Yes, the application was Siebel. The difficulty I was having was reproducing the query behavior within a cursor. The execution plan used by the cursor was different than the execution...

We have i3 from Symantec. Neat tool, but VERY expensive.

If you have multiple filegroups, did you move any objects to those filegroups?

If I create a filegroup called FG2 that contains 5 10GB data files and move table x, table...

I'd check to make sure SQL Server runs under an account that has local admin privileges on each node. Also, make the Windows cluster service account a local admin as...

There are a few scripts on the web that will rebuild indexes if they exceed a certain level of fragmentation only. Otherwise, they will defrag them.

I've seen some cases where...

Thank you so much!

Mark - the query works great! You are a gentleman and a scholar. 😀

The one bug I found in SP2, did not make it to SP3. 😎 I was told it will be fixed in CU12, due in Feb 2009. When creating a...

I was just wondering if somehow the code running inside the cursor was ignoring any indexes already present on the table. I can't verify that it is doing a table...

Yes. All of them.

Unfortunately we don't have control over the way the client app sends the requests to the DB. We can't change it from cursors to stored procs. I can do some...

Has anyone found a solution to this? I am experiencing the same issue against a SQL 2005 database. When running a query that returns 0 records takes 15ms when run...

Also, you should consider running a 64 bit installation, so you need x64 capable CPU's, 64 bit OS, and 64 bit SQL.

Under what account is SQL Server agent running? Does this account have permission to execute this job?

(Make sure your SAN storage is already presented to your server and Windows can see it)

Log in to Cluster Administrator.

Open up the resource group where SQL Server is located.

Right Click...

http://msdn.microsoft.com/en-us/library/ms186865.aspx

http://msdn.microsoft.com/en-us/library/ms190372.aspx