Forum Replies Created

Viewing 15 posts - 1 through 15 (of 45 total)

  • RE: Check status of HEAP tables

    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. ...

  • RE: Is It Worth Upgrading to SQL Server 2008

    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...

  • RE: Is It Worth Upgrading to SQL Server 2008

    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...

  • RE: What SQL Statements Are Currently Executing?

    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...

  • RE: Undocumented Extended and Stored Procedures

    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


  • RE: Search in your T-SQL objects

    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'...

  • RE: Search in your T-SQL objects


    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...

  • RE: A Simple way of Automating Scripts


    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....

  • RE: A Simple way of Automating Scripts

    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...

  • RE: Execute SQL job through batch file

    ** 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....

  • RE: Execute SQL job through batch file

    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...

  • RE: Mastering SQL Server Profiler - Part 6: Creating Custom Traces

    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...

  • RE: Keep It Simple

    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.


  • RE: Keep It Simple

    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...

  • RE: Keep It Simple


    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...

Viewing 15 posts - 1 through 15 (of 45 total)