Viewing 15 posts - 41,296 through 41,310 (of 49,571 total)
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
If the indexes on that table are appropriate and the queries well written, there shouldn't be a problem. If you want some advice on that, post the table structure, existing...
January 31, 2009 at 10:34 am
Josh Turley (1/30/2009)
I'll just add a step to the scheduled job to truncate the log then.
Ur, why?
If you need point-in-time recovery, schedule log backups.
If you don't need point-in-time...
January 31, 2009 at 10:18 am
Viewing 15 posts - 41,296 through 41,310 (of 49,571 total)