Forum Replies Created

Viewing 15 posts - 16,246 through 16,260 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    You will see several examples at http://ask.sqlservercentral.com/questions/4241/whats-the-best-way-to-solve-the-fizzbuzz-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

    March 18, 2010 at 1:59 pm

    #1136285

  • RE: Check status of HEAP tables

    Last comment for the moment. I like the principle of this script. Nice idea and it looks like it could be very helpful.

    Thanks.

    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

    March 18, 2010 at 1:58 pm

    #1136283

  • RE: Check status of HEAP tables

    JStiney (3/18/2010)

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

    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

    March 18, 2010 at 1:57 pm

    #1136282

  • RE: Check status of HEAP tables

    Mark D Powell (3/18/2010)

    I copied it into notepad and used the edit/replace option to replace a copy/paste of the stupid little squate box to space. That seemed to work...

    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

    March 18, 2010 at 1:56 pm

    #1136281

  • RE: Need T-SQL equivalent to Access First()

    J-F Bergeron (3/18/2010)

    CirquedeSQLeil (3/18/2010)

    A windowed function such as this would be my first suggestion to solving the question.

    Thanks for the vote of confidence Jason, 😛

    We do not know if the...

    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

    March 18, 2010 at 1:51 pm

    #1136277

  • RE: Disable foreign keys

    It should be more like this

    alter table TableName Drop constraint FK_Name

    Then perform your truncate

    Then this

    alter table TableName

    Add constraint FK_Name Foreign Key (FieldName) References OtherTable (FieldName)

    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

    March 18, 2010 at 1:48 pm

    #1136274

  • RE: Are the posted questions getting worse?

    Paul,

    I am curious why you changed your alias to include NZ.

    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

    March 18, 2010 at 1:46 pm

    #1136272

  • RE: Send output of "Execute Sql Task" to a table

    Elliott W (3/18/2010)

    Matt Miller (#4) (3/18/2010)

    Elliott W (3/18/2010)

    Before saying "don't use SSIS for this" you need to ask more questions. The biggest one is how much data are we...

    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

    March 18, 2010 at 1:43 pm

    #1136271

  • RE: Need T-SQL equivalent to Access First()

    J-F Bergeron (3/18/2010)

    Here is a query you can use, but you will need to add a datetime field you probably have in your table in the sorting. It's just a...

    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

    March 18, 2010 at 1:41 pm

    #1136267

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/18/2010)

    Steve Jones - Editor (3/18/2010)

    BTW, someone pinged me about a GTR posting bad info and causing trouble. Anyone have complaints, or are these other teaching moments?

    Speaking of the...

    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

    March 18, 2010 at 1:19 pm

    #1136249

  • RE: Are the posted questions getting worse?

    john.arnott (3/18/2010)

    Lynn Pettis (3/17/2010)

    Like clustered indexes are better than nonclustered indexes?

    Sometimes I think about teasing my DBA by saying stuff like "since clustered indexes are better than non-clustered, could...

    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

    March 18, 2010 at 1:17 pm

    #1136247

  • RE: Connecting SQL Server 2005 Express Edition on Static IP

    You need to configure your firewalls and routers to permit traffic between the locations. The port setting will depend on your database setup (some use default port, others configure...

    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

    March 18, 2010 at 11:55 am

    #1136192

  • RE: transaction log restore question

    jorge.torralba (3/18/2010)

    Brandie Tarvin (3/18/2010)

    Any chance I can change your mind on this? Relying on db snapshots as a permanent part of your backup plan is not necessarily a good idea....

    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

    March 18, 2010 at 11:52 am

    #1136191

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/18/2010)

    You can put MVP in your signature all you want, but you can't link to this unless you have one.

    Remember, MVP is about service to the community. Some,...

    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

    March 18, 2010 at 11:18 am

    #1136176

  • RE: Are the posted questions getting worse?

    David Burrows (3/18/2010)

    Paul White NZ (3/18/2010)

    jcrawf02 (3/18/2010)

    MVP doesn't necessarily mean that you know what you're talking about, just that you're an MVP on a specific topic

    I know...really I do...I have...

    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

    March 18, 2010 at 11:08 am

    #1136168

Viewing 15 posts - 16,246 through 16,260 (of 19,560 total)