Forum Replies Created

Viewing 15 posts - 1 through 15 (of 145 total)

  • RE: Is there any testing tool available to test SQL proc / functions

    only4mithunc (4/17/2011)

    Hi friends,

    Is there any testing tool available for the testing of SQL Stored procedures/functions? . Like the Nunit testing , NAND for .Net code I'm looking for some testing...

    April 28, 2011 at 1:34 pm

    #1317508

  • RE: where to learn 'advanced' querying

    All of the above. Reading everything you can lay hands on is really useful, especially if it's something you have already read about but presented from a different perspective....

    March 22, 2010 at 6:47 pm

    #1137946

  • RE: Does a development DBA need to learn dot.net language. ?

    ... Went back to being an FTE on a salary and doing some consulting work on the side. Of course, you really have to be careful not to...

    March 22, 2010 at 6:22 pm

    #1137941

  • RE: Does a development DBA need to learn dot.net language. ?

    Jeff Moden (3/21/2010)

    I guess I'm the oddball. I've totally removed myself from such languages and have concentrated on T-SQL. Sounds stupid, I know, but when folks hire me,...

    March 22, 2010 at 3:57 am

    #1137471

  • RE: Does a development DBA need to learn dot.net language. ?

    CirquedeSQLeil (3/17/2010)

    As I have read more comments on the topic, I would have to sway more favorably to the definitely learn .Net side of the fence. ...

    I'm late to the...

    March 21, 2010 at 5:53 am

    #1137330

  • RE: Checking Up on Developers

    Michael Lysons (5/8/2009)

    Good grief, sweeping generalisation about developers there, Steve. Seems to me that if a developer is implementing incorrect indexes etc, then it's actually the DBAs fault for...

    May 8, 2009 at 5:24 am

    #990981

  • RE: SET vs SELECT

    Atif Sheikh (5/6/2009)

    SELECT do not change the value if it is not initialized by the statement. Also, if the multiple records returned from the SELECT statement, the value of last...

    May 7, 2009 at 7:14 am

    #990323

  • RE: SET vs SELECT

    I'm also in the It Depends camp. One of the determining factors is the source of the value going into the variable. If it's coming from a SELECT...

    May 5, 2009 at 1:15 pm

    #989129

  • RE: spid blocked itself

    karthikeyan (2/18/2009)

    Hi Gurus,

    I ran one process in of the sqlserver 2000 database that process id was 230 and same process was blocked itself.

    why is it happend frequently.

    Thanks in advance.

    Sorry for...

    February 25, 2009 at 6:49 am

    #949940

  • RE: Staging table population

    dhanasekar.palani (1/28/2009)

    I have a main table which has 55 million rows..I am populating a staging table from the main table with the conditions as from date to date...I wrote...

    January 30, 2009 at 7:57 am

    #935557

  • RE: SQL or Oracle

    Jeff Moden (1/16/2009)

    hb21l6 (1/16/2009)

    It would appear that I have made a bit of a stir with this question. Sorry all,

    I think I’ll just stick at my MS SQL. Should be...

    January 21, 2009 at 8:33 am

    #930401

  • RE: Image is Everything

    Interesting topic and lots of good feedback. The whole image question falls under the opinion category and, as we all know, opinions are like feet. Everyone has them...

    January 9, 2009 at 6:18 am

    #924082

  • RE: Common Mistakes in T-SQL

    hbpank (12/30/2008)

    what are the Common Mistakes in T-SQL ?

    For example: @@Error gives correct value in next line only. after that it Value gets Reset.

    Do we have any compilation...

    January 2, 2009 at 6:05 am

    #920218

  • RE: Return Average build cost based on last 5 Orders

    Philip Horan (12/30/2008)

    Hi. Where to begin....I need to arrive at an average build cost for a Product taking into account all associated costs.

    ...

    Hi, Phil. You may have already gotten...

    January 2, 2009 at 5:34 am

    #920202

  • RE: Deleting temp tables in the system "tempdb".

    Warren Peace (12/30/2008)

    lol...

    I was thinking the same thing.

    She must speak in HEX.

    So now we know - Gail's smart AND hexy! :w00t:

    January 2, 2009 at 5:23 am

    #920193

Viewing 15 posts - 1 through 15 (of 145 total)