Forum Replies Created

Viewing 15 posts - 451 through 465 (of 2,463 total)

  • RE: need book on perfmon counters

    rajkiran.panchagiri (1/22/2013)

    I need a material for sql perfmon counters. It should contain threshold values for those counters and definiton of those counters.

    Also There are tons of articles on this....

    January 22, 2013 at 2:53 am

    #1579502

  • RE: Handling Stored Procedure

    abivenkat (1/22/2013)

    since it is going to get executed parallely by 5 threads and how can i handle the insert, delete and truncates inside the SP? will it be a problem,...

    January 22, 2013 at 1:16 am

    #1579473

  • RE: Concurrent Database Access Per Instance

    i dont think there is any limitation of connections .SQL Server will handle large numbers of connections without a problem. A more important question is whether your database schema and...

    January 22, 2013 at 1:09 am

    #1579469

  • RE: Join on nvarchar column using LIKE

    praveen_vejandla (1/22/2013)

    UPDATE LII

    SET value_exists = 1

    FROM LII od

    JOIN VPL sl

    ON (sl.it like '%' + od.value + '%'

    AND od.opr =...

    January 22, 2013 at 1:05 am

    #1579467

  • RE: How to Improve the perforamce of large tables ?

    kbhanu15 (12/12/2012)

    Hi All,

    Please give your valuable suggestions on how can i improve the performance of tables which having 2 crores of data.

    Thanks

    Bhanu

    have you made any changes with this...

    January 22, 2013 at 12:42 am

    #1579463

  • RE: High Volume of SQL Compilations/sec

    Imke Cronje (1/16/2013)

    We currently have an issue where on one of our SQL Servers, there is a high number of SQL Compilations\sec. There was no new code promoted to the...

    January 22, 2013 at 12:40 am

    #1579462

  • RE: about Transanctional Replication

    Yes , create a publication for those selected tables.

    January 22, 2013 at 12:18 am

    #1579457

  • RE: about identity column

    mpradeep23 (1/21/2013)

    i have table which as identity column which as primary key it is related to lot of tables .how do i reset the identity order

    IF you are...

    January 22, 2013 at 12:17 am

    #1579455

  • RE: SCAN count + OR Strategy

    karthik M (1/21/2013)

    All,

    I found some wierd thing today when i ran the below two

    version of queries.

    select * from sub_fund

    where sub_fund_id in (1,2,3,4,5,6,7,8,9,10)

    scan count = 10

    select * from sub_fund

    where sub_fund_id in...

    January 22, 2013 at 12:14 am

    #1579454

  • RE: Linked Servers

    NaDi (1/21/2013)

    the remote login, & password that I have set is exactly the same as the log in credentials that I am using whenever I connect to the Database Server...

    January 21, 2013 at 11:36 pm

    #1579450

  • RE: Execute statement in CATCH block

    khushbu (1/21/2013)

    IF-ELSE block is working. But I would like try the statements in TRY-CATCH block, while there are some additional statements in CATCH block to report.

    Catch is generally used...

    January 21, 2013 at 11:26 pm

    #1579447

  • RE: Name search with Full Text Search

    try FREETEXT instead of CONTAINS

    January 21, 2013 at 11:16 pm

    #1579441

  • RE: Detect missing indexes

    definitely above query will provide you some hint BUT not tell you exact picture, i will suggest you to pick the long running or resource intensive queries, have a detailed...

    January 21, 2013 at 11:12 pm

    #1579440

  • RE: Linked Servers

    it seems that this issue is "permission related". Check the login used in linked server should have appropriate credentials.

    January 21, 2013 at 11:09 pm

    #1579439

  • RE: Execute statement in CATCH block

    khushbu (1/21/2013)

    Hi,

    Need some help in determining if the below statement is good enough.

    How can I get statement to execute in Catch block?

    I'm out of ideas..

    IF (SELECT is_broker_enabled FROM...

    January 21, 2013 at 11:07 pm

    #1579438

Viewing 15 posts - 451 through 465 (of 2,463 total)