Katmai was the code name for SQL 2008 before it was release.

You can download the database from: http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=18407

Thanks.

If you are running those DBCC you probably know the first time it is running slow because it is creating the execution plan for the store procs. I Haven't...

index_depth is not an indicate on how fragementation it is an indication on how big is your index. An index is a b+ tree. So if you have...

pobeda (3/12/2009)

---

Hello all,

quick question, sql 2005 maint. plan would not let you specify fill factor for re-indexing job.

Would this be safe to assume, that it will use server default fill...

But you can gain performance gain from adding another file if you put it on different spindle on your San :).

If it is not available growing the Files would be...

I am not sure what you are asking? Are you wondering can Index be fragmented at high depths? Yes, but it will not show affect unless it is...

I wasn't suggesting it wasn't sorry if it sounded that way ...

Mohit.

Four entries can be generated because the value passed in with the statement prompted SQL Server to make a new execution plan.

You can get the execution plan using following query:

SELECT...

You can use a function to do you check constraint ...

Ref: http://msdn.microsoft.com/en-us/library/ms188258.aspx

How often are you doing you T-Log backup? The transaction log will keep growing and the transactions will not get truncated until you do backup.

So lets say ..

8AM You...

You can look at using OPENROWSET function, look at link.

Thanks.

Only way I can think of doing it by means of an add-in but my .NET skills are hmm .. well I don't have :hehe:. IF you find a...

Have a read at ... http://www.databasejournal.com/features/mssql/article.php/3085211/Linked-Servers-on-MS-SQL-Part-1.htm

:).

Thanks.

He said that because of ...

And it makes sense in my little mind because if he has...

I execute:

SELECT * FROM sys.dm_db_index_physical_stats(db_id, NULL, NULL,NULL,'LIMITED')

This gives me information for a Single Database, all tables, and all indexes. The 'LIMITED' gives be very brief information about Index depth,...