Forum Replies Created

Viewing 15 posts - 1,261 through 1,275 (of 6,486 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (11/30/2010)

    Alvin Ramard (11/30/2010)

    I'm still not sure about the number of records this might returned.

    Who knows? Unless I'm missing something, it's a cross join between T2 and T3 (there's no...

    December 1, 2010 at 7:48 am

    #1257369

  • RE: JOINing in the WHERE clause?

    CELKO (11/30/2010)

    The one predicate I like is generalized equality. I can do it with some work and <expr> = ALL(<table constructor >), but it would to do an n-way join...

    November 30, 2010 at 7:04 pm

    #1257111

  • RE: Do You Talk Salary in the Interview?

    Tim Mitchell (11/28/2010)

    I'm in favor of talking about salary ranges early on, preferably before either party has spent significant time in the process (for example, during the initial phone screening)....

    November 28, 2010 at 2:04 pm

    #1256068

  • RE: Do You Talk Salary in the Interview?

    Jeff Moden (11/25/2010)

    I agree... I usually don't even entertain the idea of an interview unless I already know the salary range. I don't want to waste their time or...

    November 26, 2010 at 5:25 am

    #1255784

  • RE: Replacing "hard-codes"

    You could always build a procedure to rebuild the functions with hard-codes: just script out the alter statement into a dynamic SQL script. You could even set up a...

    November 24, 2010 at 6:03 am

    #1255017

  • RE: Google Scale

    Michael Valentine Jones (11/16/2010)

    Experienced developers, like Jeff, understand that doing a crap job the first time around and then having to fix it is much more expensive than doing a...

    November 16, 2010 at 12:19 pm

    #1251539

  • RE: simple delete statement

    wannalearn (11/15/2010)

    Update the values with ABCD0123 if 3 digit

    update the values with ABCD1234 IF 4 digit

    for the same column now.

    what would be sql statement?

    Thanks

    You just changed the question around. ...

    November 16, 2010 at 12:04 pm

    #1251525

  • RE: Is xp_cmdshell the only option?

    Lowell (11/4/2010)

    GSquared (11/4/2010)

    Since VB.NET can create text files pretty easily, a CLR proc would do the job, and be more secure than xp_cmdshell.

    how would you get the CLR to write...

    November 4, 2010 at 7:06 pm

    #1246950

  • RE: Get the Current Date

    Brandie Tarvin (10/28/2010)

    Sean,

    Thanks for pointing out that he's talking about syntax, but when I go back to read his post, he's saying ANSI is more readable than T-SQL.

    I don't know...

    October 29, 2010 at 11:47 am

    #1244359

  • RE: When Times are Tough, Do You Rise to the Occasion?

    Ninja's_RGR'us (10/18/2010)

    How would you guys react? I still have full access to all source codes and their backups. I have no intent to destroy there servers and yet...

    October 18, 2010 at 4:32 pm

    #1238781

  • RE: SQL SERVER 2000 Retrieve Data using IntMth n intYear Parameter

    Also - I can't help but notice that you are using what looks to be something like LinQ syntax instead of TransactSQL code. firing that code off as a...

    October 18, 2010 at 6:43 am

    #1238367

  • RE: Differences

    Steve Jones - SSC Editor (10/11/2010)

    Dan Guzman - Not the MVP (10/11/2010)

    Excellent followup article Steve, and JenMidnightDBA, where do I find your blog?

    You can find Jen here: http://www.midnightdba.com/Jen/

    ... Did I...

    October 11, 2010 at 8:35 pm

    #1235286

  • RE: Data Portability

    Steve - I read over the facebook article you mentioned, and while I did see the parts about being able to TRANSFER your data from Facebook to other sites, there...

    October 11, 2010 at 9:58 am

    #1235094

  • RE: Data Portability

    ldsudduth1 (10/10/2010)

    Actually, HIPAA only applies to medical records maintained by healthcare providers; but this device is *not* encrypted; making me extremely wary, since it also has personal information (name, address,...

    October 11, 2010 at 9:50 am

    #1235079

  • RE: Extended Store Procedures in Functions workaround suggestions?

    Agreed -

    The code looks a bit longer, but it would probably work a LOT faster to skip the function entirely and build this out as a direct SQL statement....

    October 10, 2010 at 6:38 pm

    #1234738

Viewing 15 posts - 1,261 through 1,275 (of 6,486 total)