I would like to run your script, but I get invalid characters in blank spaces when I copied it out of the window and ran it in Management Studio. ...

There is an error in the database sizes from my previous post, should be Gig not Meg.

(531 Meg to 106 Meg and 239 Meg to 44 Meg) should be (531...

SQL 2008 Compression and Table Partitioning are not to be underestimated. They have allowed us to easily justify going to Enterprise Edition instead of Standard Edition when we upgrade from...

Thanks for the script. I can see that it will be useful.

This is the kind of script that I will create as a .sql file in a regular...

The following is a much more flexible and much more useful version of sp_who/2 that I have been using for a number of years.

/* Author: Richard Ding

**...

Thanks rVadim,

I changed the ??? to blanks and the script works for me.

declare @SearchCriteria nvarchar(100)

set @SearchCriteria = '%MEAG_MASTER%' ---------> enter criteria here

select distinct

@SearchCriteria as ZoekCriteria

, 'in code'...

Wilfred,

I get the following message on the select statement when I inserted

set @SearchCriteria = '%MEAG_MASTER%' and executed the script.

Any suggestions?

Msg 170, Level 15, State 1, Line 5

Line 5: Incorrect...

Michael,

If you are referring to my package alternative, I don’t get scripts from developers.

I get the package after it has been tested by successfully running it in the Test/QA environment....

Let me suggest another simple method to implementing production database changes.

Use a DTS or SSIS Package.

Several years ago we agreed with our development staff that all database changes would be...

** Correction - osql has not been deprecated.

It is still working in SQL 2008, but according to BOL (This feature will be removed in a future version of SQL Server....

The use of cmd files to execute sql is a powerful tool that is underutilized, if the lack of posts is any indicator.

I use cmd files to run almost all...

Thanks Brad well done.

I use profiler infrequently, but I did know most of what was in lessons 1 - 5.

However a review doesn't hurt when you don't use the tool...

If anyone wants the original scripts they are available at the address below.

I believe she did add a fix after I got them, but I have not had any problems.

I...

I run this stored procedure on all my databases on all my servers every night and have done so since 2004. The vast majority of the tables do not need...

Steve,

Should we reindex all tables every night because we can?

I'm surprised you asked this one.

I got a script that checks fragmentation using dbcc showcontig and only runs reindex...