Viewing 15 posts - 43,276 through 43,290 (of 49,552 total)
Karl Klingler (11/7/2008)
just so i know - do you guys think it possible that an open transaction getting rolled back on the table might be a reason for this kind...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 8, 2008 at 3:23 am
Build 1399 is RTM, meaning it's never been patched at all. The latest will be SP2 CU 10. Get SP2 and apply it to the machine where the client tools...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 8, 2008 at 3:20 am
Depends. Was record a deleted before Diff2 was taken, or afterwards?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 8, 2008 at 3:15 am
Logins can be created on the mirror, because logins go into the master database. Make sure that you script the login from the principal with the SID. That will ensure...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2008 at 3:01 pm
Does the path F:\MSSQL.1\MSSQL\LOG\ exist?
If so, what files are in there?
Are there any other errror relating to tempDB or Model in the error log?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2008 at 2:57 pm
Can you ask the users what exactly they mean by 'locking'?
dbcc traceon(1204, 1222, 3605, -1)
3605 isn't required for deadlock graphs. Personally I find 1204 to be unnecessary if 1222 is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2008 at 2:06 pm
Did you do anything to the tempdb files? Did you copy then anywhere, rename anything or anything like that. Basically, what did you do to the server between the time...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2008 at 2:03 pm
You're dividing by t.SoldYR1 in the code that works and t.SoldYR2 in the code that doesn't. Are there any rows where t.SoldYR2 is 0?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2008 at 2:01 pm
These two should give you a good place to start. You may have to tweak an existing script if you can't find one that does exactly what you want.
http://www.sqlservercentral.com/scripts/Index+Management/63649/
http://www.sqlservercentral.com/scripts/SQL+Server+2005/61278/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2008 at 1:54 pm
clive (11/6/2008)
If you truncate a log file which is usually around 2GB, but is now 7GB due to bulk inserts, truncating it is recommended (unless you have plenty disk space...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2008 at 1:50 pm
TRACEY (11/6/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2008 at 1:44 pm
Post it on Connect. Make sure you've applied the latest service pack and CU before you do so, so that you know that it hasn't already been fixed.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2008 at 11:45 am
Dinendra Nath Dolai (11/5/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2008 at 11:42 am
Check the scripts library here, there are lots and lots of variations floating around
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2008 at 11:40 am
Matt Miller (11/6/2008)
Is there not going to be a Dev edition for 2008?
It exists. I'm running 2 installations of it. Though I got mine from MSDN and I don't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2008 at 11:39 am
Viewing 15 posts - 43,276 through 43,290 (of 49,552 total)