Viewing 15 posts - 37,261 through 37,275 (of 49,566 total)
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...
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...
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...
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,...
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.
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....
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...
August 7, 2009 at 4:47 am
Is there blocking, are there waits? If so, what's the wait type?
August 7, 2009 at 4:39 am
How big is the index in question?
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.
August 7, 2009 at 3:06 am
Raymond Xu (7/14/2008)
1. Create DB for attach ...
CREATE DATABASE database_name
ON ...
August 7, 2009 at 3:02 am
Michael Oberhardt (7/14/2008)
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,...
August 7, 2009 at 2:59 am
BobAtDBS (7/14/2008)
August 7, 2009 at 2:57 am
Rajesh kasturi (8/7/2009)
I am just searching find alternate ways to recover for different scenario.There might be solution
Answer my questions about what you're doing with the transaction log and I'll...
August 7, 2009 at 2:55 am
Viewing 15 posts - 37,261 through 37,275 (of 49,566 total)