Forum Replies Created

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

  • RE: SQL Server 2008 R2 Logs

    Check out this KB article and see if it helps you. http://support.microsoft.com/kb/958006

    November 14, 2013 at 8:11 am

    #1666396

  • RE: REGEX

    Stewart "Arturius" Campbell (11/14/2013)

    Agree with the point regarding regex in T-SQL. .Net is definitely much more efficient in this regard...

    +1 Thanks for the great question.

    November 14, 2013 at 7:56 am

    #1666388

  • RE: Automatic Page Repair

    Ed Wagner (11/12/2013)

    I didn't know the answer either and had to research it. I got to learn something today and it's still early. 😀 Thanks for a good...

    November 12, 2013 at 7:18 am

    #1665723

  • RE: Using Max()

    Thomas Abraham (11/8/2013)

    Thanks for the question!

    However, the drama of saying that it caught out all your staff made me spend way too much time on it. Thinking I was...

    November 8, 2013 at 8:28 am

    #1665137

  • RE: SQLCMD

    Jeff Moden (11/5/2013)

    SQLRNNR (11/5/2013)

    Jeff Moden (11/5/2013)

    Heh... I had to think about it. For me, the correct answer would have started with "Exec xp_CmdShell". 😀

    not sp_configure??

    :w00t::-D

    Heck no. I leave...

    November 6, 2013 at 6:56 am

    #1664450

  • RE: 9002 ERROR

    Koen Verbeeck (10/29/2013)

    Nice question, learned something. Thanks.

    +1 I almost picked DOA for giggles. I don't know why, but that just made me laugh this morning. 😀

    October 29, 2013 at 7:42 am

    #1662355

  • RE: Date Functions

    Toreador (10/24/2013)

    For me, a better answer is to subtract one from the first day of the next month, as this method will allow the same code to be run on...

    October 24, 2013 at 7:42 am

    #1661281

  • RE: Sequence

    EZPZ 🙂

    October 16, 2013 at 7:22 am

    #1658873

  • RE: ISNUMERIC(varchar)

    pchirags (10/15/2013)

    easy question..

    there is an excellent explanation from Jeff moden..

    http://www.sqlservercentral.com/articles/IsNumeric/71512/

    +1 I was thinking about the same article pchirags. 😀 I've ran into a few issues like this with...

    October 15, 2013 at 8:08 am

    #1658541

  • RE: Field Lengths

    Thanks for the great question! EZ one for Friday. 🙂

    October 11, 2013 at 7:37 am

    #1657911

  • RE: Hekaton

    OCTom (10/4/2013)

    Hekaton reminds me of old sci-fi movies. "Godzilla versus Hekaton".

    +1 Haha, that made me laugh this morning. Good question to end the week on; just so happened to be...

    October 4, 2013 at 6:52 am

    #1655868

  • RE: Database permissions

    Good question, thanks.

    October 3, 2013 at 7:50 am

    #1655562

  • RE: T-SQL counts

    Great question. Almost overlooked the distinct in the count().

    October 2, 2013 at 1:51 pm

    #1655322

  • RE: Extended Procs

    Koen Verbeeck (9/30/2013)

    Nice question. Never even heard about it, made me do some research.

    +1 Good question. Never really used these, so it was good to do some research on it.

    October 1, 2013 at 7:59 am

    #1654918

  • RE: Truncate

    Thanks for the question!

    September 30, 2013 at 7:22 am

    #1654547

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