Viewing 15 posts - 24,556 through 24,570 (of 49,552 total)
Post the deadlock graph please
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
August 1, 2011 at 1:23 pm
John H Davis (8/1/2011)
The execution plan for the functions is not included in the execution plan for the query.
No its not, but SQL still has to track the run-time information...
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
August 1, 2011 at 1:03 pm
A workaround, yes. The only solution, not even close.
The solution is to identify the cause of the deadlocks and fix it.
Switch traceflag 1222 on. That will result in a deadlock...
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
August 1, 2011 at 12:48 pm
UPDATE <table>
SET <column name> = NULL
WHERE <column name> = '1900-01-01'
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
August 1, 2011 at 12:47 pm
Where the pk is is utterly irrelevant. It's the clustered index that you need to be concerned about (the pk is clustered by default, but it's just a default)
Maybe take...
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
August 1, 2011 at 12:46 pm
frankie11 (8/1/2011)
(The issue we have is space. If we don't shrink, after reorg, we end up with a big log file, which in turn breaks Log Shipping)
A large log file...
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
August 1, 2011 at 12:44 pm
If the datetime is null, SQL will display it as null. It doesn't automatically convert any null value to a non-null value. Something in the query or the display 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
August 1, 2011 at 12:39 pm
Ninja's_RGR'us (8/1/2011)
Reallllllly old broken down laptop or the new monster you just bought?
The machine that I just replaced.
I dunno if you'd call a Core-2 Quad with 2GB RAM 'broken down'
I...
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
August 1, 2011 at 11:58 am
Ninja's_RGR'us (8/1/2011)
GilaMonster (8/1/2011)
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
August 1, 2011 at 11:50 am
Yes, it does cause a query to run longer. To return an actual execution plan, SQL has to track things during query execution that it doesn't normally track. That means...
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
August 1, 2011 at 11:46 am
You need an instance of SQL 2000 or SQL2005. Restore the SQL 7 database there, change the compatability level to 80 or 90. Take a backup, restore on the SQL...
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
August 1, 2011 at 8:55 am
sql.monkey (8/1/2011)
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
August 1, 2011 at 8:11 am
sql.monkey (8/1/2011)
So how are we supposed to check consistency now?
Restore a backup onto a secondary server and checkDB that. It's the recommended approach for large, active databases due to the...
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
August 1, 2011 at 7:29 am
That's a warning from some monitoring tool, it's not an error and it has nothing to do with log shipping. Check the monitoring tool you're using.
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
August 1, 2011 at 3:12 am
It is a good idea to have a second update statistics step, set update the column statistics only with fullscan. While the index rebuilds will update the stats associated with...
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
August 1, 2011 at 2:31 am
Viewing 15 posts - 24,556 through 24,570 (of 49,552 total)