Viewing 15 posts - 40,306 through 40,320 (of 49,552 total)
Olga B (3/17/2009)
Gila, that's what I thought, but then the panic struck.
Don't panic 😉 http://www.sqlservercentral.com/articles/65804/
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
March 17, 2009 at 2:06 pm
On SQL 2000 run DBCC UPDATEUSAGE and check again. There were 'inadequacies' in the way SQL 2000 maintained the space-used metadata in 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
March 17, 2009 at 2:04 pm
shnex (3/17/2009)
17 pages, but I have some with 2 pages or 34 that "respond" the same way to my script
Don't worry about fragmentation on tables that small. Fragmentation's only...
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
March 17, 2009 at 2:02 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic677775-146-1.aspx
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
March 17, 2009 at 1:59 pm
If you have a backup, restore from backup. It's when you don't have a backup that all sorts of tricks are needed to get the DB back.
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
March 17, 2009 at 1:55 pm
Why don't you buy the training kit? It's well worth the money spent.
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
March 17, 2009 at 1:54 pm
Stamey (3/17/2009)
Gail,Did you mean that at 50% your index would take twice the space on disk, rather than the table?
Depends what type of index. If it's the clustered index that...
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
March 17, 2009 at 1:50 pm
gdavidson (3/17/2009)
set @EventID = (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
March 17, 2009 at 9:24 am
Bob Hovious (3/17/2009)
"We're running out of time!"
Cannot run out of time. There is infinite time. You are finite, Zathras is finite. This is wrong 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
March 17, 2009 at 9:22 am
Jack Corbett (3/17/2009)
GilaMonster (3/17/2009)
Bob Hovious (3/17/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
March 17, 2009 at 8:27 am
Chris Morris (3/17/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
March 17, 2009 at 8:26 am
Bob Hovious (3/17/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
March 17, 2009 at 8:09 am
eashoori (3/17/2009)
So we are OK with the flush even if auto close is set to false?
Sorry, not sure what you're asking here. Can you rephrase 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
March 17, 2009 at 8:05 am
A database restore will always flush the cache. No way to stop it from doing so.
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
March 17, 2009 at 7:56 am
Bob Hovious (3/17/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
March 17, 2009 at 7:23 am
Viewing 15 posts - 40,306 through 40,320 (of 49,552 total)