Forum Replies Created

Viewing 15 posts - 1,996 through 2,010 (of 9,707 total)

  • RE: Linked Servers, Views, and Stored Procedures

    TANSTAAFL is big here too. Fortunately, the solution is short term. We're putting a hard date on when things need to be fixed, so no one will have any excuses.

    February 25, 2016 at 8:17 am

    #1861082

  • RE: Count of Queries

    mcopa (2/25/2016)

    What exactly do you mean by this: "if you really need to know exactly how many queries are run against the database, you need to set that up...

    February 25, 2016 at 6:53 am

    #1861038

  • RE: Are the posted questions getting worse?

    GilaMonster (2/24/2016)

    I disagree. Jupiter is descending.

    http://what-if.xkcd.com/139/

    That is an awesome link. Thanks, Gail.

    On another note, this might be one of those days when I should step away from my computer. I...

    February 25, 2016 at 6:50 am

    #1861036

  • RE: Need to build query

    rhythmk (2/25/2016)

    Brandie Tarvin (2/25/2016)

    What logic determines IN verses OUT?

    Hard coding based on the dates given is not wise. Ideally, code should be written to logically decide what fits either circumstance...

    February 25, 2016 at 6:39 am

    #1861031

  • RE: Linked Servers, Views, and Stored Procedures

    I forgot all about synonyms, but you're right. Not the best solution. For one, I can't create one that just points to the server.dbname. I just tried it, it doesn't...

    February 25, 2016 at 6:27 am

    #1861025

  • RE: SQL Server Permissions

    deltajade (2/21/2016)

    I was told that is an industry standard, I could delete because I have read / write access.

    Is this true?

    I have never run into a situation where having read...

    February 25, 2016 at 6:14 am

    #1861023

  • RE: SSIS - Data Type Issue

    sgmunson (2/23/2016)

    You might want to try CAST(PortNumber AS smallint)...

    This or try to change the INT16 in expression to INT32. But yes, INT in a database comes across as INT32 in...

    February 25, 2016 at 6:06 am

    #1861017

  • RE: Changing License From Core based to CAL

    At a guess, I would think you need to contact Microsoft.

    I don't know if this document tells you anything helpful (I haven't read through the whole thing yet). Microsoft...

    February 25, 2016 at 6:03 am

    #1861013

  • RE: Need to build query

    What logic determines IN verses OUT?

    Hard coding based on the dates given is not wise. Ideally, code should be written to logically decide what fits either circumstance depending on other...

    February 25, 2016 at 5:59 am

    #1861012

  • RE: import data from an excel to sql server

    Orlando Colamatteo (2/13/2016)

    Brandie Tarvin (2/12/2016)

    Because ... Excel .... SUCKS ... that way. :pinch:

    I would say it as "because integrating with Excel sucks that way." It is not technically Excel that...

    February 24, 2016 at 7:34 am

    #1860719

  • RE: Are the posted questions getting worse?

    Alan.B (2/23/2016)

    I don't know if anyone is aware of this but I noticed Dwain Camps hadn't posted anything in awhile so I checked his blog (dwaincsql.com), simple-talk, twitter, linkedin... then...

    February 24, 2016 at 7:22 am

    #1860712

  • RE: Are the posted questions getting worse?

    djj (2/18/2016)

    Hey, who shut down the water cooler? I do not post often here, but I read it every day. Usually there is a lot going on by...

    February 24, 2016 at 7:12 am

    #1860705

  • RE: How do we get the definition of tables via sql

    mw112009 (2/12/2016)

    I don't have a need to understand how SQL SERVER works. That is not a part of my job.

    Honestly, if knowing how SQL Server works is NOT part...

    February 12, 2016 at 11:27 am

    #1858467

  • RE: smtp logging into sql server using ODBC connections

    So what smtp stuff are you logging? IIS stuff? Or database mail?

    February 12, 2016 at 11:16 am

    #1858461

  • RE: Are the posted questions getting worse?

    Sean Lange (2/12/2016)

    Brandie Tarvin (2/12/2016)

    Thank you backup, Sean. I'm still shaking my head over the OPs initial "you're wrong, that can't be done after all" and then "Well, prove it"...

    February 12, 2016 at 8:27 am

    #1858379

Viewing 15 posts - 1,996 through 2,010 (of 9,707 total)