Forum Replies Created

Viewing 15 posts - 18,391 through 18,405 (of 19,560 total)

  • RE: Today's Random Word!

    Dynamic

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 5, 2010 at 10:13 am

    #1099053

  • RE: Dynamic SQL

    ziangij (1/4/2010)

    option C doesn't work, it throws an error while executing in sql 2005.

    You will need to change the Employees table in the variable to a valid table in...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 5, 2010 at 10:12 am

    #1099052

  • RE: Dynamic SQL

    rustman (1/5/2010)

    My SQL2008 system seems to have trouble with the 'quotename' which encloses the tablename in []. Remove that with the dbo in front of the table name and Option...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 5, 2010 at 10:11 am

    #1099051

  • RE: Dynamic SQL

    I agree with Lynn,Mark and Bitbucket. The idea is to test the code against your system using your knowledge. If that means changing a variable - then change...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 5, 2010 at 10:10 am

    #1099050

  • RE: fragmentional levels

    I would tend to lean toward the results of sys.dm_db_physical_index.

    Are the tables in question heaps or do they have clustered indexes on them?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 4, 2010 at 11:33 pm

    #1098748

  • RE: Dynamic SQL

    Thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 4, 2010 at 10:33 pm

    #1098741

  • RE: Select causing deadlock?

    What is the utility that you are using to see this deadlock graph?

    What are the queries that you suspect are causing the deadlocks?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 4, 2010 at 10:16 pm

    #1098739

  • RE: Today's Random Word!

    Tell me about it, Jimbu took me there last summer. Somewhere between Alexanders and Houttuynia.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 4, 2010 at 10:01 pm

    #1098737

  • RE: Recover Data File - MDF

    Grant Fritchey (1/4/2010)

    sudhakara (1/4/2010)

    Jack Corbett (1/4/2010)

    Sorry to say that you are basically screwed since you have no backups. Your only option is to run DBCC CHECKDB or CHECKTABLE with...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 4, 2010 at 5:57 pm

    #1098717

  • RE: Be Prepared

    GilaMonster (1/4/2010)

    But why would you need a backup? I mean, it's not as if a disk will fail, or someone drops a table (or the entire database) or the data...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 4, 2010 at 5:55 pm

    #1098716

  • RE: Zip Code search - Msg 3623 "A domain error occurred" (code inside)

    Thanks for posting back with the solution.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 4, 2010 at 5:48 pm

    #1098713

  • RE: Issue with attaching SAN snapshot replicated database files

    You will need RW to the folder and the files.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 4, 2010 at 5:46 pm

    #1098711

  • RE: shrink sql server 2000 log

    I believe this article will help you

    http://www.databasejournal.com/features/mssql/article.php/3587611/Cycling-the-ERRORLOG-file-and-Deleting-Backup-History-Information.htm

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 4, 2010 at 5:43 pm

    #1098709

  • RE: SQL 2005 - List Primary Key Columns

    Nice idea and this is a nice foundation script.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 4, 2010 at 5:31 pm

    #1098707

  • RE: User can access DB, but User not present under Security

    Sneaky indeed. Gotta love the backdoors. Now the question is, how many did they create?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 4, 2010 at 5:09 pm

    #1098705

Viewing 15 posts - 18,391 through 18,405 (of 19,560 total)