I'd say 99%. The fragment size is 1, indicating there are no two contiguous pages, and the number of fragments is the same as the number of pages. This index...

Steve Jones - Editor (11/16/2009)

---

The SQLGuru has hit this nail on the head. If you have a failure after TRUNCATE ONLY and before your next full backup, you can lose...

If you need some help with that, start a new thread and post (or attach) the deadlock graph, along with definitions of the tables involved.

Looks like someone needs a basic computer theory course.

Clustering: http://www.sqlservercentral.com/Forums/Topic819325-146-1.aspx

SAN: http://www.sqlservercentral.com/Forums/Topic819323-146-1.aspx

RAID: http://www.sqlservercentral.com/Forums/Topic819327-146-1.aspx

Please read through this - Managing Transaction Logs[/url]

http://www.google.com/search?q=What+is+RAID+10

Indeed. The leaf is level 0, the...

Ask the server administrator or whoever set up the physical server which drives are SAN drives and which ones are direct attached storage. Th SQL they look the same.

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

According to Paul, it was an estimate based on knowledge of the...

When looking at index fragmentation, it's usually only necessary to look at the leaf level (level 0). The others are very often small and, especially for a frequently used index)...

You trying to create a database on there? Query a database on there? Exactly what are you doing?

I'd prefer to see the screenshot, to see exactly what the path has been set to, exactly what the filename has been set to. The script's just going to show...

Aaahhhhhh!!!

http://www.sqlservercentral.com/Forums/Topic817076-146-1.aspx

Spoon feeding?

Then go to "Edit Attachments" (it's part of the user control panel) and delete some of your old uploads.