Viewing 13 posts - 1 through 13 (of 13 total)
Thanks...
That is not always feasible or practical with multi terabyte databases, it requires extra hardware and on very large systems (and ours is approaching 10tb, we already have an active/passive...
August 1, 2011 at 8:00 am
So how are we supposed to check consistency now?
Closing this as "by design" is quite ridiculous.
This needs fixing and quickly, database outages with our system literally puts peoples lives at...
August 1, 2011 at 7:13 am
Michael Ebaya (11/4/2010)
sql.monkey (11/4/2010)
November 4, 2010 at 8:01 pm
MSDTC Transactions are used which rules out mirroring.
Backing up the tail of a log is not guaranteed if you have log corruption?
Replication is in place to a number of subscribers...
November 4, 2010 at 7:58 pm
Michael Ebaya (11/4/2010)
sql.monkey (11/4/2010)
select @max-2= max(primarykey) where datecol <= 'enddate'
select primarykey, datecol, x,y,z from table where primarykey...
November 4, 2010 at 7:19 pm
TheSQLGuru (11/1/2010)
November 4, 2010 at 6:48 pm
I have a table with an unindexed date column in a table of billions of rows
I collect the lowest and highest primary keys between those dates into variables
I set...
November 4, 2010 at 6:33 pm
Thanks I thought as much
August 31, 2010 at 7:48 am
Its difficult to say without knowing more about the query and the schema. I would start by analysing the results from the post I made earlier, then maybe comparing the...
November 4, 2009 at 4:27 pm
pauljacob (11/4/2009)
Changed Degree of parallelism to 1 from 4 but same result.
Sorry, what result?
If its a resource_semaphore wait, have you tried recompiling the sproc?
Is your where clause specific...
November 4, 2009 at 8:31 am
TheSQLGuru (10/30/2009)
CXPACKET waits (parallelism) are just a mask of something more sinister going on with query performance
Hmm - in my experience CXPACKET waits are almost always the result of a...
November 4, 2009 at 7:34 am
a resource semaphore wait type is typically waiting on a memory grant, check pending/outstanding memory grants in perfmon. That's normally because a query plan has compiled in a "non-optimal" fashion....
October 29, 2009 at 2:42 pm
Viewing 13 posts - 1 through 13 (of 13 total)