Viewing 15 posts - 16 through 30 (of 40 total)
What version of SQL Server are you running, and also what isolation level is it running at? If you're on 2005 or higher consider moving to Read Committed Snapshot isolation....
July 10, 2012 at 8:11 am
Unless I'm mistaken, that article doesn't delineate which fall into the "Other" bucket.
As additional color on the topic I should probably have provided, when I look at Activity Monitor,...
July 10, 2012 at 5:24 am
Finnlake (4/1/2010)
We...
March 19, 2012 at 3:24 pm
There's 5 CU's to SP1 already, something else to look into. We've been debating whether to (and when to) start moving to the latest CU.
March 7, 2012 at 9:54 am
The reason I was asking about ASP.NET has to do with a bug in transaction scope, and if you don't know how to look at it then it's really hard...
February 28, 2012 at 9:22 am
They don't double ding you for being able to use high availability (if you need 2 servers to accomplish that, you don't need 2x the licensing). That's the general idea....
February 27, 2012 at 7:24 pm
This smells like somethings we recently ran into, we actually had 3 things going on and solving both fixed it for us. Three questions:
1. Is this being run by a...
February 27, 2012 at 6:52 pm
Did a google search and found this which matches an issue I'm currently having. Were you ever able to fix it?
February 27, 2012 at 6:15 pm
And also check this directly from Microsoft as well: http://msdn.microsoft.com/en-us/library/ms190747.aspx
February 21, 2012 at 12:40 pm
An easy way is to, through SQL Management Studio, restore the database but before you actually restore it when you first click on the media where you "Specify Backup" click...
February 21, 2012 at 12:38 pm
Ok, my poking around on this topic was due to some behavior I was seeing in our database, and thankfully we've now also found the root cause of it. Dan...
February 20, 2012 at 12:06 pm
His user name isn't "Ten", it's "J Livingston SQL". Seeing small differences like that which you may have overlooked is why it's sometimes helpful to provide the DDL for review....
February 17, 2012 at 2:18 pm
You're also safer doing it like this, note the brackets.
BEGIN tran
UPDATE DW.Table1
SET [Key] = 5
ROLLBACK;
February 17, 2012 at 2:07 pm
Some generic questions:
1. What SQL Server version? "select @@VERSION"
2. Are any of the tables temporary tables?
3. Since you posted psuedo code, can you reproduce it with psuedo code?
4. Have you...
February 17, 2012 at 2:00 pm
What is the definition for dbo.GetLocalDateTimeFunc?
February 17, 2012 at 1:53 pm
Viewing 15 posts - 16 through 30 (of 40 total)