Forum Replies Created

Viewing 15 posts - 1,531 through 1,545 (of 5,685 total)

  • RE: I need only SQl Server Agent

    Gianluca Sartori (5/23/2012)

    Sorry to say that, but I don't think you should be using SQL Server Agent as a job scheduler if you don't need SQL Server in the first...

    May 23, 2012 at 3:09 pm

    #1492156

  • RE: Are the posted questions getting worse?

    SQLRNNR (5/23/2012)

    SQL Kiwi (5/23/2012)

    Bye Jason. Schoolboy error.

    Nope -planned psychological experiment.

    This isn't a psychological experiment unless you're trying to determine the psychosis of a Bronco's fan in light of the...

    May 23, 2012 at 3:05 pm

    #1492154

  • RE: Not exactly code review or source code control

    If you can't clarify with the end user, the intermediary has to. If the intermediary won't, then you need to go up your own chain of command and back...

    May 23, 2012 at 2:28 pm

    #1492132

  • RE: I need only SQl Server Agent

    Tara-1044200 (5/23/2012)

    I wanted to use SQL Server Agent for shcduling the windows jobs as i think sql jobs more robust than windows schduler, do i have install the complete server...

    May 23, 2012 at 2:20 pm

    #1492121

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/23/2012)

    SQLRNNR (5/23/2012)

    Steve Jones - SSC Editor (5/23/2012)

    Stefan Krzywicki (5/23/2012)

    Tom Brady? He'll be retiring soon.

    We can only hope.

    Nah - I want to see him beat down the Broncos and...

    May 23, 2012 at 2:15 pm

    #1492114

  • RE: Are the posted questions getting worse?

    Pardon me, I'd just like to vent briefly about SSRS.

    YOU LOUSY PIECE OF DUNG INANE INTERFACE. MS ACCESS has more ability and stronger methodology than YOU! YOU ARE...

    May 23, 2012 at 1:28 pm

    #1492078

  • RE: Will partitioning help?

    GilaMonster (5/22/2012)

    andersg98 (5/22/2012)

    Yes. The concept is called 'partition elimination'. Especially when scanning the table for a date range, the optimizer will realize it only has to scan the...

    May 22, 2012 at 2:47 pm

    #1491421

  • RE: Are the posted questions getting worse?

    SQL Kiwi (5/22/2012)

    Stefan Krzywicki (5/22/2012)

    Lynn Pettis (5/22/2012)

    If people would just format their code they could figure out some of their own problems. Geez.

    Many should format it all at once,...

    May 22, 2012 at 1:46 pm

    #1491354

  • RE: Many to one TOP N UPDATE troubles

    I debated on leaving this alone since the OP is good to go but I don't want to see others confused by this. Although, if you're going to boilerplate...

    May 18, 2012 at 5:40 pm

    #1490032

  • RE: rows to columns

    chandrika5 (5/18/2012)

    The problem I have is:

    descr

    Amt

    Cnt

    are variables and can go upto 15 also. I do not have control on these fields as these are configurable by users.

    Ignoring our local wild...

    May 18, 2012 at 5:29 pm

    #1490023

  • RE: Query Cost 27%

    Alright, I found where I pulled .3% out of ... the Aether... and realized why I'd done it.

    For those interested, a more in depth discussion can be found here from...

    May 18, 2012 at 4:26 pm

    #1490003

  • RE: Query Cost 27%

    GilaMonster (5/18/2012)

    Evil Kraig F (5/18/2012)

    I think I'll go re-read your blog a few times until it gets better stuck in my head. 🙂

    That's not on my blog. It's stuff I've...

    May 18, 2012 at 4:15 pm

    #1490002

  • RE: Query Cost 27%

    GilaMonster (5/18/2012)

    Evil Kraig F (5/18/2012)

    Apologies for the confusion. Yeah, my numbers were off too, sorry, it's 0.003 or .3%... and I dropped it in the middle of the two,...

    May 18, 2012 at 4:05 pm

    #1489998

  • RE: Importing Multiple csv files into one SQL Table

    Jeff Moden (5/18/2012)

    Lowell (5/18/2012)

    I'll go all devils advocate on the SSIS guys and present a solution i put together for other posts that is all TSQL.

    Thsi requires xp_cmdshell to get...

    May 18, 2012 at 3:57 pm

    #1489992

  • RE: Query Cost 27%

    Jeff Moden (5/17/2012)

    No problem. Thanks.

    I ran the test you included in the Blog entry and actually did get seeks at the .5% and .3% levels instead of scans, but...

    May 18, 2012 at 3:14 pm

    #1489975

Viewing 15 posts - 1,531 through 1,545 (of 5,685 total)