Viewing 15 posts - 20,371 through 20,385 (of 26,490 total)
ps (6/20/2009)
Paul White (6/20/2009)
Lynn Pettis (6/20/2009)
If we just give him answers and he ends up in a position that he isn't qualified for do, who's fault is it, ours or...
June 20, 2009 at 11:03 am
ps (6/20/2009)
Lynn Pettis (6/20/2009)
ps (6/20/2009)
Well it looks as if someone's put his exam question papers here to be solved ..:-Dhttp://www.sqlservercentral.com/Forums/Topic738841-146-1.aspx
Well (and yes, that is a mighty deep subject for a...
June 20, 2009 at 10:38 am
ps (6/20/2009)
Well it looks as if someone's put his exam question papers here to be solved ..:-Dhttp://www.sqlservercentral.com/Forums/Topic738841-146-1.aspx
Well (and yes, that is a mighty deep subject for a weekend) I have...
June 20, 2009 at 10:25 am
narinder (6/20/2009)
2.How many type of mirroring
3.Difference between transaction replication and merge replication
4.If your database primary file size is 40 GB and log...
June 20, 2009 at 10:23 am
Also, just because you have a solution doesn't mean that someone else may not have another way of doing the same thing. Sometimes better, sometime not. Many times,...
June 19, 2009 at 4:19 pm
All you have to do to use my code is figure out how to change "March 2009" to 2009-03-01.
Example, using a yet to be defined function: set @RunDate =...
June 19, 2009 at 12:27 pm
Roy Ernest (6/19/2009)
June 19, 2009 at 12:20 pm
Unrelated maybe, but puzzling. WHERE 1=1?
Allows additional conditions to be added, commented, etc while writing the query. Looks like a testing method so you don't have to worry about...
June 19, 2009 at 12:17 pm
Change: WHERE poi.DueDate = @TriggerDate
To: WHERE poi.DueDate = dateadd(dd, datediff(dd,0,@TriggerDate),0)
Does that help?
June 19, 2009 at 8:00 am
mazzz (6/19/2009)
Has SSC ever had a thread like this?
There have been a couple of threads where people have asked for free books, but mostly related to SQL here, not on...
June 19, 2009 at 6:09 am
You are asking for performance help, even if you don't know it. I can't tell you one way or the other based solely on your description. The first...
June 18, 2009 at 8:47 pm
What else changed? Prior to the failure, were you running in a clustered environment or was this a change that was being made moving to a clustered environemnt?
June 18, 2009 at 8:44 pm
Hard to really say. Please take the time to read the 2nd article I have referenced in my signature block below reagrding asking for assistance with performance issues. ...
June 18, 2009 at 8:18 pm
Pretty sure you can setup log shipping using a Standard Edition versions of SQL Server, you just have to do all heavy lifting yourself, no wizards.
June 18, 2009 at 8:06 pm
Rollie D Moe (6/18/2009)
IS IT IMPOSSIBLE TO REDUCE THE SIZE OF THAT LARGE LOG FILE?
Please do not use all CAPS in your posts.
🙂
June 18, 2009 at 2:50 pm
Viewing 15 posts - 20,371 through 20,385 (of 26,490 total)