Nice question - learned something new from it .. THANKS

david.wright-948385 (8/3/2013)

---

Steve Jones - SSC Editor (8/2/2013)

---

Some of you might have noticed that the "Yesterday's Question of the Day" is back in the newsletter (today's).

...we had some authors of...

BigChicagoBob (7/30/2013)

---

First, thank you for the warm welcome.

Second, I have a few many questions for you gurus.... if you don't mind pointing me in the correct direction!

bitbucket-25253 (7/30/2013)

---

...It will allow...

I would suggest purchasing the DEVELOPER EDITION, whose use does not run out with time. Cost is around $50 US dollars. It will allow you to save what...

You might want to read this:

http://msdn.microsoft.com/en-us/library/ms188664(v=sql.90).aspx

It shows you how to use the Copy Database Wizard which is available.

If any one misses this basic question ... woe to the place where they work

The world is a richer place for the diversity we have, and varying opinions, thoughts and ideas. We don't all get along, but many of us can work together with...

Here is one I use .. it does NOT do what you requested as far as rebuilding, but you should be able to modify it to perform that task. ...

There is a method. Read this to learn how to use.

http://msdn.microsoft.com/en-us/library/ms175850(v=sql.100).aspx

Suggest you read this: (SQL Server Upgrade Advisor) at:

http://www.microsoft.com/en-us/download/details.aspx?id=11455

Use the Developer Edition .... as long as it is NOT used in production it is equivalent to the Enterprise Edition.

Use GOOGLE to search for a site where you can...

+1

we need filtered dump (only once) on the exception 12345 then we can enable trace flag 2551,8026 :

dbcc traceon (8026,2551,-1)

2551 –> To configure the filtered dump

8026 –>To clear the...

Steve Jones - SSC Editor (6/14/2013)

---

Lynn Pettis (6/14/2013)

---

***************************************************

I am officially going to Afghanistan!

I leave for IRDO at Camp Atterbury in Indiana on Sunday, June 23rd. All should go well...

ben.brugman (6/10/2013)

---

With sp_space_used you get the 'gross' size of a table. (Used_size for data)

Summing all fields with a datalength function also gives a size for a table, offcourse this is...