Viewing 15 posts - 38,941 through 38,955 (of 49,552 total)
If a database is detached while in the recovering or standby state, it cannot be reattached (baring some odd hacks that may or may not work)
In fact, in SQL 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
May 23, 2009 at 9:59 am
Which SQL tool?
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
May 23, 2009 at 9:46 am
That's a heap (table that doesn't have a clustered index). It can't be defragmented because there's no index there to defragment.
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
May 23, 2009 at 7:15 am
Where are you measuring those IOs from?
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
May 23, 2009 at 4:00 am
How big are the indexes that aren't defragmenting? How many pages?
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
May 23, 2009 at 3:56 am
Bear in mind that all costs are estimates, no matter whether it's an estimated or actual plan. There are a number of factors that could make them wrong.
Will look 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
May 22, 2009 at 3:26 pm
RBarryYoung (5/22/2009)
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
May 22, 2009 at 3:10 pm
Jan Van der Eecken (5/22/2009)
You are a very brave person, Gail.
Didn't really have many choices at the time.
SQL 2000 on Itanium. Critical production system (stock market trading). SQL completely unresponsive,...
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
May 22, 2009 at 3:08 pm
Jan Van der Eecken (5/22/2009)
Guess he should enhance DBCC with an option "RECOVER FROM SQLKILL" 😛
Fortunately, as long as the log and data files are intact, that usually doesn't cause...
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
May 22, 2009 at 2:50 pm
Gaby Abed (5/22/2009)
In trying to determine which are the best candidates, I queried sys.dm_db_index_physical_stats.
I'm curious. What's in index physical stats that you're using to determine the best clustered index?
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
May 22, 2009 at 2:39 pm
These errors are the result of someone directly editing the system tables on SQL 2000. They are not the result of the upgrade.
In SQL 2000, CheckDB did not include...
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
May 22, 2009 at 2:31 pm
Lynn Pettis (5/22/2009)
You may also want to post the plans here, but I'm not sure how to have you do that with SQL Server 2000.
Add the following line above 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
May 22, 2009 at 2:23 pm
As I already said, SQL will not automatically release memory. Don't worry about the memory. You have plenty (16GB), SQL's using 10 or so, that's quite normal and not a...
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
May 22, 2009 at 6:13 am
Jan Van der Eecken (5/22/2009)
GilaMonster (5/21/2009)
Oh yay. 🙁Another email accusing me of personal attacks and damaging someone's public image by 'misleading' people about his statements.
Sometimes I wonder why I bother.....
You...
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
May 22, 2009 at 4:20 am
dallas13 (5/21/2009)
dbcc traceon(1204,3605,-1)dbcc traceon(1205,-1)
dbcc traceon(3604,-1)
All of above...
You don't need all of those. If you're looking for deadlocks, the only one that you need is 1204.
1205 adds a lot, lot more...
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
May 22, 2009 at 3:40 am
Viewing 15 posts - 38,941 through 38,955 (of 49,552 total)