Forum Replies Created

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

  • RE: Put first line as column name

    Hi guys,

    Could somebody help me? This is a bit urgent

    Best regards

    July 8, 2013 at 7:13 am

    #1630424

  • RE: Put first line as column name

    Yes, you are right about dynamic queries into functions. When I wrote about "the other functions work as well" I said the other functions are inserting information into a...

    July 2, 2013 at 4:02 pm

    #1629310

  • RE: Put first line as column name

    Sean Lange (7/2/2013)

    ulisseslourenco (7/2/2013)

    Thanks for respond me.

    I have a question: Is allowed use exec statement into a function? I ask that because I have to return a...

    July 2, 2013 at 2:55 pm

    #1629285

  • RE: Put first line as column name

    Thanks for respond me.

    I have a question: Is allowed use exec statement into a function? I ask that because I have to return a select into a...

    July 2, 2013 at 1:35 pm

    #1629266

  • RE: Avoid exporting "enter character" on the footer

    I looked for an option -r newline character in bcp command, but it is applying in whole lines. In my case except footer can have that character.

    May 14, 2013 at 12:36 pm

    #1615145

  • RE: Question about query hint nolock

    GilaMonster (4/13/2013)

    ReadPast = skip locked rows. Also rather bad for accurate results. Find for stuff like dashboards or areas where close to accurate is good enough

    If you're having problems with...

    April 13, 2013 at 5:10 am

    #1606240

  • RE: Question about query hint nolock

    Jeff Moden (4/12/2013)

    If you're really trying to prevent blocking, then try the READPAST hint instead of the troublesome NOLOCK hint.

    Hi

    I read about readpast command and it isn't good as nolock....

    April 12, 2013 at 10:34 pm

    #1606233

  • RE: something like PIVOT?

    SQLDCH (4/12/2013)

    I have a table that stores a tablename, the last time the table was accessed and when that data was put into the table:

    CREATE TABLE [dbo].[LastSelectCheck](

    ...

    April 12, 2013 at 4:13 pm

    #1606184

  • RE: Question about query hint nolock

    GilaMonster (4/12/2013)

    There is, but to be honest you shouldn't be using nolock everywhere. It's not a go-faster switch, it is not a performance tuning technique, it is not necessary to...

    April 12, 2013 at 3:40 pm

    #1606176

  • RE: Copying columns to same table in other database

    John Mitchell-245523 (12/14/2011)

    Try building your ALTER_TABLE statement as a @sql variable. Then you can PRINT @sql as well as EXEC (@sql). If any of the statements fail to...

    December 16, 2011 at 12:56 am

    #1422329

  • RE: Why bcp import a file out of order in SQL 2008?

    opc.three (11/4/2011)

    ulisseslourenco (11/1/2011)

    Hi guys

    There is an application in my company which imports files inside several tables on database. However when there are simultaneous files, a lot of them import registers...

    November 16, 2011 at 8:15 am

    #1408583

  • RE: Before create a procedure send a trigger to a table

    Lowell (8/9/2011)

    ulisseslourenco (8/9/2011)

    GSquared (8/9/2011)

    You can use DDL triggers to fire on creation of a procedure. They can check values in tables. Will that do what you need?

    In fact...

    August 9, 2011 at 2:35 pm

    #1366277

  • RE: Before create a procedure send a trigger to a table

    GSquared (8/9/2011)

    You can use DDL triggers to fire on creation of a procedure. They can check values in tables. Will that do what you need?

    In fact I would...

    August 9, 2011 at 12:17 pm

    #1366138

  • RE: Each table in Owner Filegroup

    GilaMonster (5/1/2011)

    ulisseslourenco (5/1/2011)

    In fact, My manager based in split multiple text files in same disk is faster to seek some information than a big file so he thought if...

    May 1, 2011 at 8:40 am

    #1318176

  • RE: Each table in Owner Filegroup

    GilaMonster (5/1/2011)

    ulisseslourenco (4/30/2011)

    In fact if I move a big table to other filegroup I will gain some performance howerver separating each table I will gain some performance? and same disk?

    Unless...

    May 1, 2011 at 8:00 am

    #1318166

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