Viewing 15 posts - 37,246 through 37,260 (of 49,552 total)
talltop (8/7/2009)
shrink in size or not grow and thus cure an out of disk space...
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 7, 2009 at 5:51 am
This is from a presentation that I did earlier this week at TechEd
-- cumulative execution stats for the queries in cache
select * from sys.dm_exec_query_stats
-- the 10 longest running queries
SELECT TOP...
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 7, 2009 at 5:34 am
When a backup is restored it always recreates the database exactly as it was at the time of the backup. If there are no indexes after the restore it 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 7, 2009 at 5:31 am
Mark Horninger (8/7/2009)
GilaMonster (8/7/2009)
Bill Whitman (7/14/2008)
A maintenance plan should be set up to truncate, shrink, and backup the transaction log -- nightly, if necessary.
Absolutely not. That's terrible advice to be...
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 7, 2009 at 5:18 am
Anyone seen today's article? The article's fine but some of the comments are scary....
Example:
A maintenance plan should be set up to truncate, shrink, and backup the transaction log -- nightly,...
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 7, 2009 at 5:17 am
If you put a clustered index on a view, the view is materialised and stored almost as if it was a table.
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 7, 2009 at 4:49 am
venu_ksheerasagaram (8/7/2009)
Is there any way to make the free space release to OS.
Why do you want to do that? Databases tend to grow as more data gets put in them....
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 7, 2009 at 4:47 am
Edit: Sorry, noticed after posting it was SQL 2000
In SQL 2000, you can query the syscacheobjects table, but there's very little useful information in there. No where close to what...
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 7, 2009 at 4:47 am
Is there blocking, are there waits? If so, what's the wait type?
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 7, 2009 at 4:39 am
How big is the index in question?
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 7, 2009 at 3:13 am
Small indexes often don't reindex properly, but it's not a concern. 1000 pages is usually cited as the point where one starts to worry about fragmentation in an 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
August 7, 2009 at 3:06 am
Raymond Xu (7/14/2008)
1. Create DB for attach ...
CREATE DATABASE database_name
ON ...
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 7, 2009 at 3:02 am
Michael Oberhardt (7/14/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
August 7, 2009 at 3:01 am
Bill Whitman (7/14/2008)
A maintenance plan should be set up to truncate, shrink, and backup the transaction log -- nightly, if necessary.
Absolutely not. That's terrible advice to be giving.
Backup the log,...
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 7, 2009 at 2:59 am
BobAtDBS (7/14/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
August 7, 2009 at 2:57 am
Viewing 15 posts - 37,246 through 37,260 (of 49,552 total)