Viewing 15 posts - 41,281 through 41,295 (of 49,558 total)
Marios Philippopoulos (2/2/2009)
Not that I don't believe you, but can you post a link that mentions...
February 2, 2009 at 6:17 am
Arun (2/1/2009)
February 1, 2009 at 11:50 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic647819-361-1.aspx
February 1, 2009 at 11:49 pm
Varchar(8000) stores a maximum of 8000 characters. Varchar(max) stores a maximum of 2 147 483 647 characters.
See Books Online, the page titled "char and varchar" for more info.
February 1, 2009 at 11:41 pm
What DB are you restoring?
Can you post the code that you're using to do the restore?
February 1, 2009 at 11:39 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic647812-146-1.aspx
February 1, 2009 at 11:38 pm
colin Leversuch-Roberts (2/1/2009)
OP ?
Original Poster
In theory doing a select * may seem a solution, however having observed memory usage from many angles, including having 64GB of ram for...
February 1, 2009 at 11:36 pm
RBarryYoung (2/1/2009)
But Marios should be able to get the Actual from Profiler or tracing, right?
Yes, absolutely. Providing he traces the correct event. I seem to recall there are about 6...
February 1, 2009 at 11:34 pm
Marios Philippopoulos (2/1/2009)
I don't think it's the estimated exec plan, I obtained it from sys.dm_db_exec_requests. It was retrieved when the statement was actually executed...
It's the same as the 'estimated' plan....
February 1, 2009 at 2:06 pm
binettec (2/1/2009)
February 1, 2009 at 10:11 am
Jeff Moden (2/1/2009)
February 1, 2009 at 10:03 am
Check the SQL error log. There should be an entry that states why SQL is marking the databases suspet. If you'renot sure, post that and any other error messages relating...
February 1, 2009 at 5:17 am
Can you perhaps post the trigger code?
February 1, 2009 at 5:16 am
Perry Whittle (1/31/2009)
as Gail pointed out remember that to make the passive node active would require a new set of disk resources for the 2nd active instance.
And even if...
February 1, 2009 at 5:14 am
Phillip Cox (2/1/2009)
shared scalable databases
Just for your info, scalable shared databases are not a new 2008 feature. 2005 had the capability. It wasn't well knows, I doubt it was used...
February 1, 2009 at 5:00 am
Viewing 15 posts - 41,281 through 41,295 (of 49,558 total)