Forum Replies Created

Viewing 15 posts - 301 through 315 (of 374 total)

  • RE: Date Puzzle

    henrik staun poulsen (10/27/2010)

    '31-Jan-2010'

    It that the correct (international) way to hard-code dates?

    I think I would have used '2010-01-31' or is it '20100131' to ensure that it will work around the...

    Thanks

    October 27, 2010 at 12:29 am

    #1242678

  • RE: To Fetch Records from a table quickly which is having 10 Lakhs record

    You are referring SQL 2005, so

    please refer: http://msdn.microsoft.com/en-us/library/cc917715.aspx

    Thanks

    October 26, 2010 at 10:50 pm

    #1242651

  • RE: To Fetch Records from a table quickly which is having 10 Lakhs record

    You can create Indexed view - add Index on the view.

    As per BOL:

    "An indexed view is a view that has been materialized. This means it has been computed and stored....

    Thanks

    October 26, 2010 at 10:48 pm

    #1242650

  • RE: Date Puzzle

    Question is simple but nice one.

    Thanks

    October 26, 2010 at 10:44 pm

    #1242649

  • RE: varchar issue

    MonsterRocks (10/26/2010)

    DECLARE @PVC_LOGIN_USERVARCHAR(40),

    @PVC_APPLICATION_IDVARCHAR(40),--yet to finish

    @PVC_PROGRAM_NAMEVARCHAR(40),

    @PI_RET_STATUSINT,

    @PVC_RET_MSGVARCHAR(500),

    @PI_RET_ERRORNUMINT,

    @PVC_APPLICATION_NAMEVARCHAR(50), @pvc_dest int;

    my declaration is mentioned above

    As per the declaration above, I dont see any errors while executing...

    Thanks

    October 26, 2010 at 2:36 am

    #1242080

  • RE: Enable Broker Service

    Good question with nice/tricky options.

    I was thinking for following options are the candidates:

    ALTER DATABASE db2 SET DISABLE_BROKER ; ALTER DATABASE db2 SET ENABLE_BROKER;

    ALTER DATABASE db2 SET NEW_BROKER

    But after reading...

    Thanks

    October 26, 2010 at 12:45 am

    #1242050

  • RE: Instant File Initialization

    Nice question. I learn something new.

    Thanks

    October 25, 2010 at 10:43 pm

    #1242026

  • RE: Trigger - ntext column value

    ruchir 71291 (10/25/2010)

    Thanks for providing good solution.

    Before I change datatype from ntext to nvarchar(max), I would like to know the difference between ntext and vvarchar(max).

    Thanks,

    Ruchir

    ntext datatypes will be deprecated in...

    Thanks

    October 25, 2010 at 12:17 am

    #1241423

  • RE: which cmd or function can transfer printed message to a sql file?

    You can also use "xp_logevent"

    like: EXEC xp_logevent 60000, <<your message>>, informational

    It Logs a user-defined message in the SQL Server log file and in the Windows Event Viewer. xp_logevent can be...

    Thanks

    October 22, 2010 at 12:33 am

    #1240731

  • RE: MCITP without MCTS Certification

    WayneS (10/21/2010)

    Simon-413722 (10/21/2010)

    Hi,

    I'm just wondering if you could register and take MCITP exam and skip MCTS?

    No, MCTS is a prerequisite

    I want to clear 70-431 - Microsoft.SQL.Server.2005.Implementation.and.Maintenance in next month but...

    Thanks

    October 21, 2010 at 10:00 pm

    #1240703

  • RE: Identity column concurrency

    I was thinking that due to multiple user is entering the data at same time, it may generate primary key violation.

    Thanks

    October 21, 2010 at 4:16 am

    #1240139

  • RE: How Truncate statement ?

    w.rooks (10/21/2010)

    The error you will get is: CostomerMast does not Exist!!!

    The table is called CostomerMastER

    This was typo mistake.

    If you change it to CustomerMaster still SQL throws an error:

    Cannot truncate table...

    Thanks

    October 21, 2010 at 12:40 am

    #1240079

  • RE: How Truncate statement ?

    Nice question.

    Delete is working for CustomerMaster table but truncate throws an error. I would like to know why it is not working? Any specific reason?

    Thanks

    October 20, 2010 at 11:51 pm

    #1240065

  • RE: Activity Monitor Permission

    As per the BOL:

    To view the Activity Monitor in SQL Server 2005 and SQL Server 2008, a user must have VIEW SERVER STATE permission.

    To view the Activity Monitor on...

    Thanks

    October 19, 2010 at 11:56 pm

    #1239483

  • RE: What's the best way to count?

    Really nice question & good knowledge sharing conversation.

    Thanks

    October 19, 2010 at 9:05 am

    #1239099

Viewing 15 posts - 301 through 315 (of 374 total)