Viewing 15 posts - 41,311 through 41,325 (of 49,571 total)
myst.black (1/30/2009)
Is it possible to set up replication on the passive node instead? If so, what are the drawbacks?
Bear in mind that, with clustering there's only a single copy of...
January 31, 2009 at 10:12 am
Please read through the article that Terry posted, and also this one - Managing Transaction Logs[/url]
January 31, 2009 at 10:10 am
Probably something's missing in the error handling. Can you post the outer stored proc?
January 31, 2009 at 10:10 am
sqlfriend (1/30/2009)
January 31, 2009 at 9:59 am
colin Leversuch-Roberts (1/30/2009)
January 30, 2009 at 11:45 am
I would suggest that you run a CheckDB at your earliest convenience, as more checks are done in 2008 then were in 2000 or earlier.
May the Force be with you.
January 30, 2009 at 3:01 am
baumgaertner (1/30/2009)
- Is there no workaround to have two batches in one if-condition?
Dynamic SQL, or Christopher's deferred naming trick
if (level = 1)
begin
alter table tblCustAttrDefValue add strHelpValue...
January 30, 2009 at 1:38 am
Bruce W Cassidy (1/29/2009)
sometimes it's fun having a good ol' mud-slinging match with someone who is absolutely sure they are right. And sometimes that's even me!
We can...
January 29, 2009 at 2:33 pm
In the future, if you do that, please edit the incorrect post to point to the new one, then anyone who reads it knows that it's not to be replied...
January 29, 2009 at 2:31 pm
Generally, I start with 1/2 or 1/4 the number of cores, and see if there's any contention on the allocation pages in Tempdb (which is the reason for splitting). If...
January 29, 2009 at 2:12 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/Topic646379-149-1.aspx
January 29, 2009 at 2:02 pm
SG (1/29/2009)
That's what I started with before I tried the distinct, I tried it again but still got duplicates.
Can you strip the query down to just the essentials (that still...
January 29, 2009 at 1:59 pm
Temp tables are specific to the connection that created them, and they will be dropped when that connection closes. If you want a table that multiple users can use, rather...
January 29, 2009 at 1:45 pm
I'll check tomorrow, if someone hasn't got there first.
January 29, 2009 at 1:41 pm
Per database.
Again, only really useful if you have IO problems and the file are going on separate physical drives
Why are you thinking 1 file per cpu per filegroup? What was...
January 29, 2009 at 1:41 pm
Viewing 15 posts - 41,311 through 41,325 (of 49,571 total)