SQL 2K8

Partitioned tables

Clustered

Mirrored

200Tb SAN

Paul White (12/17/2009)

Oh. No - not intending a joke - but I...

satisfaction

I think it is a nice combination of both. There is an inborn desire to break things, or take things apart to see how it might work. Teaching...

In SQL 2005, this can be accomplished through the use of a recursive CTE.

It sounds like you are building a Binary Tree, is that so?

I would go to the client and propose two options - fix it (not a band-aid) or leave it as is. We had a funky setup similar to that...

Please also the provide stored procedure and table structures.

This sounds reasonable (have done a very similar thing).

For the executing query text, this should get you headed in the right direction.

select

session_id

,start_time,command, st.text

,last_wait_type

from sys.dm_exec_requests r

cross apply sys.dm_exec_sql_text(sql_handle) AS st

go

Try this:

Add the IP and the FQDN of the witness to your DNS server. Add the fully qualified domain name of the principal and the witness in the host file...

And after you reconfigure for the 2GB, what happens when you update stats?

Also, is the bad plan consistent? Is it slow on repeated executions of the query?

That outclasses my laptop. I only have 2GB on it and am running SQL 2008 (and Server 2003). Performance is fine for what I am doing - development...

correct on the getdate()

Just set the fields to be default values of the functions listed.

Then again, maybe not.

Looks like it may be time for a new one already.

Were you getting any error messages for the maintplan?

From Technet:

The Rebuild Index Task uses the ALTER INDEX statement when connected to SQL Server 2005, and the DBCC DBREINDEX statement when...