Viewing 15 posts - 21,856 through 21,870 (of 49,552 total)
john.arnott (12/7/2011)
or was my initial guess right, that MS has an error in the BOL?
Wouldn't be at all surprising. You can post it as a connect item and ask for...
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
December 8, 2011 at 2:50 am
Not one, but there are three that when combined mostly replace it (there is still some bits missing)
sys.dm_exec_connections
sys.dm_exec_sessions
sys.dm_exec_requests
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
December 8, 2011 at 2:43 am
Lowell's code shows the last time that a table or index was accessed in some way. So if it's showing 2 days ago, someone ran a query or some form...
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
December 7, 2011 at 10:45 am
Have you considered Read Committed Snapshot? It just needs turning on at a database level. Snapshot needs enabling at a database level and then the queries have to explicitly select...
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
December 7, 2011 at 10:40 am
If it's a dedicated SQL box, leave the processor affinity at the default settings. 25% cpu usage is on the low side. 70%+ sustained and I might start to worry.
Sounds...
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
December 7, 2011 at 10:38 am
First, why READ UNCOMMITTED? Are you sure that the data anomalies are acceptable?
Your code seems to have been cut off, so can't see where you would put the if.
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
December 7, 2011 at 8:56 am
A covering index is not a particular type of index. An index is said to be covering for a query if that index contains all the columns that the query...
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
December 7, 2011 at 8:29 am
update dd set PDFExists=1
FROM @DocData dd INNER JOIN @PDFData pdf ON dd.fileId=pdf.OriginalFileId
Other than the missing join, the table variables either need to be aliased or enclosed in []
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
December 7, 2011 at 8:26 am
shaun.stuart (12/7/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
December 7, 2011 at 8:23 am
fanzhouqi (12/7/2011)
as you describe,maybe you can try repair your .net framework 3.5 or 4.0
It's not a .net error. It's a problem recovering the database.
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
December 7, 2011 at 7:50 am
fanzhouqi (12/7/2011)
the page lock in sql server 2008 x64 is configure by AWE,but you can't close it.
Huh?
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
December 7, 2011 at 7:49 am
That's part of the recompilation thresholds, not the whole story. You missed the case where the table is empty to start (which a temp table would be). Read a couple...
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
December 7, 2011 at 7:02 am
striker-baba (12/7/2011)
the .mdf and .ldf are still in same old location, but still the server is not startingup.....
You need to move/copy (preferably copy) those files to the new location....
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
December 7, 2011 at 6:56 am
Dev (12/7/2011)
GilaMonster (12/7/2011)
Dev (12/7/2011)
Optimizer can create statistics on columns. Uses actual row count for generation execution plan.
Estimated row count, not actual. The optimiser doesn't go off...
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
December 7, 2011 at 6:52 am
Dev (12/7/2011)
Yes. But it will recompile only if number of rows cross Recompilation Threshold else NO.
And tell me, what are the recompilation thresholds for a temporary table? Since...
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
December 7, 2011 at 6:51 am
Viewing 15 posts - 21,856 through 21,870 (of 49,552 total)