Viewing 15 posts - 4,801 through 4,815 (of 6,679 total)
Yeah, that's what I thought you were doing - and at least for my immediate manager reporting on the actual server name would be better. But, either way works...
July 22, 2009 at 11:22 am
If this is causing you a problem and you can't get them to stop - you can always set the trace flags to make those options noops instead. Review...
July 21, 2009 at 5:22 pm
Looks very good - I like it. One small change you might consider:
Remove @server variable - replace with @@servername global variable. That is, if what you want to...
July 21, 2009 at 2:53 pm
John Rowan (7/21/2009)
July 21, 2009 at 2:36 pm
Differential backups are cumulative - in other words, they contain all of the changes in the database since the last full backup.
In your case, I would expect to find a...
July 21, 2009 at 1:57 pm
On x64 systems, it is highly recommended that you set a max memory setting. If you don't, then it is likely that SQL Server will take all of the...
July 21, 2009 at 1:53 pm
I would have done the following:
SELECT * FROM #tempa
EXCEPT SELECT * FROM #tempb;
July 21, 2009 at 1:43 pm
This issue was first reported here: http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=127177
And, fixed here: http://support.microsoft.com/kb/919611/
July 21, 2009 at 1:39 pm
How many instances do you have in the cluster? When you apply a hotfix for SQL Server 2005 in a cluster, all nodes are updated for the specified instance.
You...
July 21, 2009 at 1:25 pm
PaulB (7/20/2009)
Slick84 (7/20/2009)
Would the inserts go first or the updates?
Two questions...
1- Are we talking about a small OLTP alike transaction OR are we talking about a large ETL alike transaction?
2-...
July 20, 2009 at 3:40 pm
I would handle it using transactions. Whether that was in a try/catch block or not would depend on what was being done.
July 20, 2009 at 3:30 pm
I would perform updates first, then inserts. If you perform inserts first, then you are going to update the rows that were just inserted - which is just a...
July 20, 2009 at 2:41 pm
2147483647 in mb
What does this mean ?
Hint: 1024MB = 1GB, 10240 = 10GB and 102400 = 100GB. So, what does that number really mean?
Does it mean that I...
July 19, 2009 at 4:33 pm
You still need to identify what is writing to the model database. The transaction log will not grow unless there is activity being performed in the database. Not...
July 17, 2009 at 2:09 pm
Jason Shadonix (7/17/2009)
July 17, 2009 at 12:48 pm
Viewing 15 posts - 4,801 through 4,815 (of 6,679 total)