Forum Replies Created

Viewing 15 posts - 121 through 135 (of 271 total)

  • RE: SQL Cop and SQLServerCentral

    What is meant by an undocumented procedure? Is it an undocumented MS procedure?

    If it can include user defined procedures, then what constitutes a documented procedure?

  • RE: The mysteries of life, the beginning of the 20th century

    I didn't pick it, but I still think "Little James will be fired" is the correct answer.:-D

  • RE: How to Design, Build and Test a Dynamic Search Stored Procedure

    Can't express my agreement strongly enough with the following:

    I really hate it when I have to wade through what I’d call “stream of consciousness” or write-only SQL. This is...

  • RE: BREAK

    david.gugg (3/4/2015)


    archie flockhart (3/4/2015)


    Curious as to why the Break doesn't exit from the IF , as the referenced BOL page suggests that it should ? ( It clearly does work...

  • RE: BREAK

    archie flockhart (3/4/2015)


    Curious as to why the Break doesn't exit from the IF , as the referenced BOL page suggests that it should ? ( It clearly does work as...

  • RE: Starting a New Job

    jackson.fabros (2/19/2015)


    I've read (and enjoyed) the original post that focused primarily on what a DBA should do on day one.

    Aside from the obvious (stop, listen, take notes, repeat),...

  • RE: Starting a New Job

    Stephanie Giovannini (2/13/2015)


    I've been an employee, contractor and consultant. Many of the places I've worked have not allowed any personal devices. No USB drives, no access to personal email, no...

  • RE: Grant Fritchey Reviews Minion Reindex

    Grant, Thanks for bringing this to our attention.

    Sean and Jen, I'm impressed by your responsiveness.

  • RE: The PIVOT

    I got it right primarily because I had just finished reading an article by Robert Sheldon earlier today. He did a great job explaining this at a beginner level....

  • RE: Getting Distinct

    Bob Cullen-434885 (1/23/2015)


    Thanks Hugo for a perfectly clear explanation!:-)

    One of the things I appreciate about this site are the people like Hugo that are willing to spend time helping the...

  • RE: Excel treating filtered area like a table

    Koen Verbeeck (1/19/2015)


    I have run against the same issue with filter tables in Excel. In the end I filtered them out just like you did.

    With your greater expertise, it's reassuring...

  • RE: Identity Data Types

    SQLRNNR (1/13/2015)


    Dana Medley (1/13/2015)


    Fantastic!

    Get that bug!:hehe:

    Love it.

  • RE: IMPLICIT_TRANSACTIONS & BEGIN TRAN

    Good question. I got it wrong :(, but I learned something :-).

  • RE: NULL Aggregates

    Xavon (1/7/2015)


    Ed Wagner (1/7/2015)


    Koen Verbeeck (1/7/2015)


    Ed Wagner (1/7/2015)


    Koen Verbeeck (1/7/2015)


    Xavon (1/7/2015)


    I wonder how MS is defining 'ignore'; because I would argue that if SUM ignored NULLs, I would not have...

  • RE: What's Coming True?

    Miles Neale (1/5/2015)

    A prediction that was not on the list, is this. In 2015 we will see many experienced IT and SQL professionals retire and move into their next...

Viewing 15 posts - 121 through 135 (of 271 total)