Viewing 15 posts - 18,226 through 18,240 (of 49,552 total)
Execution contexts aren't reused, they're specific to a single query's execution. The memory space gets reused, not the contents.
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
June 6, 2012 at 1:12 pm
Anything that changes the execution plan (parallelism, joins, etc) or changes the locks could result in a different order unless you have an ORDER BY.
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
June 6, 2012 at 12:39 pm
For a real 'needs alcohol thread'... http://www.sqlservercentral.com/Forums/Topic1311832-1550-1.aspx
I do love the last comment.
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
June 6, 2012 at 12:14 pm
Top 10 by what criteria?
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
June 6, 2012 at 9:31 am
You can stop it at any 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
June 6, 2012 at 8:59 am
charipg (6/6/2012)
is DBCC CHECKDB REPAIR_REBUILD works for this issue ?
No, it won't do a thing because CheckDB couldn't run successfully to check the DB so there's no chance at...
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
June 6, 2012 at 8:26 am
Geoff A (6/6/2012)
I'm really curious as to HOW a dbcc checkdb runs cleans whilst a select query returns the I/O error...
CheckDB didn't run clean. It didn't run at all.
Msg 8967,...
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
June 6, 2012 at 7:30 am
Two things...
SQL is designed to use as much memory as you let it. It will increase it's memory usage as long as Windows is not signalling low memory.
300 for page...
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
June 6, 2012 at 7:27 am
Restore from a clean backup
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
June 6, 2012 at 7:16 am
No one suggested using SQL authentication. The question is, why is the app connecting as the machine account, not the logged in user. Is it impersonating LocalSystem or something?
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
June 6, 2012 at 7:14 am
Again, don't waste your time considering, designing or implementing partitioning if your goal is to make queries faster. It won't help much, if at all. Partitioning is not for performance,...
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
June 6, 2012 at 7:12 am
Rather than the question of whether the machine has rights to sQL (which it probably shouldn't) is the question why your app is trying to connect as the machine's account....
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
June 6, 2012 at 3:13 am
Don't suppose your table is partitioned?
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
June 6, 2012 at 3:01 am
Then don't waste your time looking at partitioning, it's not a performance-related tool.
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/ and we'll see what we can...
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
June 6, 2012 at 3:01 am
Ok... corrupt database for extra fun. Do you have good backups?
DBCC CHECKCATALOG (<Database Name>)
GO
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Post ALL results.
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
June 6, 2012 at 2:59 am
Viewing 15 posts - 18,226 through 18,240 (of 49,552 total)