That URL migh actually work 😉

http://icanhascheezburger.com/2011/12/15/funny-pictures-http-status-cats/%5B/url%5D

It's a common question. If you don't know about it then you can't find it :-P!

The "correct" google keywords would be something like "Sql Server concatenation stuff for xml".

:hehe:

Easy fix but low priority bug last time I checked with Steve.

david.searle (12/15/2011)

---

Understood - I think this is exactly what I am experiencing.

The avg fragmentation on some of these indexes is 100% however they have a page count of 2 so...

david.searle (12/15/2011)

---

Thanks for the prompt reply - I've checked out the page counts on each and they seem really low (12 or less) so I'm guessing that could be it.

Yes!...

Best script around for that task => http://sqlfool.com/2011/06/index-defrag-script-v4-1

Smaller indexes can't be defragged. 1000 pages is the "common" treshold where it start to matter.

Anything under 8 pages just won't defrag.

Here's a sample, you need to play with this to really understand how this works.

SELECT

T.name,

STUFF((

...

Couldn't checkpoint be blocked by the single user mode? Not sure if that requires a second connection, but it sounds possible!

Fraggle-805517 (12/15/2011)

---

And the moment has arrived. After a total execution time of 15:54:22 I finally have an execution plan for everyone to view.

Jeff/Gila, can either of you...

DUDE, comma, you're the dev.

/joke

Script them from 2005 and run the script on 2008.

Google not working??

@GS dude YOU'RE THE DEV :-D:hehe:

The 2 girls with recruitment links? was clearly spam. One who actually tried to be nice tho.

You need to recreate the users on the new server, but then the permissions on the db level should work.

Build list :

http://www.sqlservercentral.com/articles/SQL+Server+2008/63491/

SP2