Forum Replies Created

Viewing 15 posts - 2,926 through 2,940 (of 9,703 total)

  • RE: Are the posted questions getting worse?

    WayneS (1/18/2015)

    I'm curious...

    How many folks have a home lab set up with servers?

    I used to. I need to set one up again.

    How many folks just use virtual machines on...

    January 20, 2015 at 5:46 am

    #1771411

  • RE: Are the posted questions getting worse?

    Ed Wagner (1/16/2015)

    Brandie Tarvin (1/16/2015)

    GilaMonster (1/15/2015)

    Sean Lange (1/15/2015)

    I am having a discussion with somebody who swears that using

    EXISTS(select 1

    is way faster than just select *. I know Gail has...

    January 16, 2015 at 5:39 am

    #1770721

  • RE: Are the posted questions getting worse?

    GilaMonster (1/15/2015)

    Sean Lange (1/15/2015)

    I am having a discussion with somebody who swears that using

    EXISTS(select 1

    is way faster than just select *. I know Gail has an article on her...

    January 16, 2015 at 5:32 am

    #1770719

  • RE: Are the posted questions getting worse?

    Sean Lange (1/15/2015)

    I am having a discussion with somebody who swears that using

    EXISTS(select 1

    is way faster than just select *. I know Gail has an article on her blog...

    January 15, 2015 at 12:18 pm

    #1770538

  • RE: Exam 70-461 question

    Ohhh. I shall take a look. Thank you for the reference.

    January 15, 2015 at 5:11 am

    #1770411

  • RE: SQL query to check log shipping error

    Peter2012 (1/13/2015)

    Hi Brandie,

    Thank you for your response.

    Those errors are coming from SQL logs, so there should a way to extract them using SQL query. This is what I'm looking for.

    So...

    January 15, 2015 at 5:01 am

    #1770406

  • RE: Execute SQL task issue

    I am positive that you are trying to squeeze too much data into the variable, but I cannot find anything on the internet that indicates how much data an object...

    January 15, 2015 at 4:56 am

    #1770405

  • RE: Are the posted questions getting worse?

    Luis Cazares (1/14/2015)

    Brandie Tarvin (1/14/2015)

    Koen Verbeeck (1/14/2015)

    Luis Cazares (1/14/2015)

    Congratulations Koen! When I grow up I want to be like you. :hehe:

    Action figures will soon be available! 😎

    With or without superhero...

    January 15, 2015 at 4:47 am

    #1770398

  • RE: Exam 70-461 question

    Koen Verbeeck (1/14/2015)

    Make sure you have a good grip on the new window functions introduced in SQL 2012.

    And you know, for some reason MS still likes to ask XML related...

    January 15, 2015 at 4:44 am

    #1770396

  • RE: Users&Roles for all db's

    I'm glad you found something you could work with.

    Happy coding. @=)

    January 15, 2015 at 4:37 am

    #1770391

  • RE: SQL query to check log shipping error

    Making the links clickable...

    lmarkum (1/14/2015)

    Peter2012,

    I did a little research and came across a link to a Microsoft Support article that discusses how this error gets triggered. That led...

    January 15, 2015 at 4:26 am

    #1770388

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (1/14/2015)

    Luis Cazares (1/14/2015)

    Congratulations Koen! When I grow up I want to be like you. :hehe:

    Action figures will soon be available! 😎

    With or without superhero capes?

    January 14, 2015 at 12:01 pm

    #1770205

  • RE: Users&Roles for all db's

    The dynamic SQL is going to be hard to get around unless you hard code all your USE DATABASE statements.

    There are two ways of getting around the sp_MSforeachdb. The...

    January 14, 2015 at 10:08 am

    #1770168

  • RE: Excel Hell using SSIS

    Koen Verbeeck (1/13/2015)

    Jimmy123 (1/13/2015)

    Fairly certain. Think I has been stung by this recently. I am now definitely thinking convert to csv.

    I tested it and the numeric value is imported as...

    January 14, 2015 at 6:04 am

    #1770078

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (1/13/2015)

    FYI, I received the Author of the Year award at MSSQLTips.com!

    Thanks everyone for voting!

    Congrats!

    January 14, 2015 at 6:02 am

    #1770076

Viewing 15 posts - 2,926 through 2,940 (of 9,703 total)