MSSQLTips.com - your daily source for SQL Server tips

Google
 
Web mssqltips.com

ESSENTIALS: Home | Tips | Search | Categories | Top 10 | Products | Authors | Blogs | Forums | Webcasts | Advertise | About
Browse by Tags -

in Search

Browse by Tags

All Tags » performance (RSS)
  • stored Procedures

    How to write stored procedures in SQL Server? Please Send the Description with examples of stored procedures. How many types of stored procedures are there in SQL Server for INSERT,UPDATE,DELETE? How to call procedures?
    Posted to Forum by kotesh on 08-09-2008
  • is it any way to avoid Rollbacking of inner transactions??

    I am having doubt - is it achivable Or not? The senario is , "If the outer transaction is rolled back, then all inner transactions are also rolled back" is it any way to avoid Rollbacking of inner transactions?? Thanks, srinivasan r
    Posted to Forum by srinivasanrr_wiz on 08-05-2008
  • If and When (clustering)

    In the next link, http://www.mssqltips.com/tip.asp?tip=1541 , there is a paragraph where it mentions that clustering in SQL server is about availability, opposite about others setups about incresasing power processing; Is there something about it (clusters for add power processing) in SQL Server (perhaps...
    Posted to Forum by maac2002 on 07-18-2008
  • Adding Alias name will improve the performances Or not?

    Hi, Do anyone can confirm me, i am little bit confused whether using alias name will improve the performances Or not? In my point of view, it won't do. Because i observed one thing by the CPU time & elapsed time is less, when i did not use alias name in my query. If it's not Helping to improve...
    Posted to Forum by srinivasanrr_wiz on 07-18-2008
  • Deadlock with READPAST on join query - how this is possible?

    Under MSSQL 2000 I get a deadlock on a transaction. This victim transaction contains one single SELECT statement joining 2 tables using the READPAST hint. I thought this hint will cause the transaction not be blocked on locks. How can it happen that the transaction is part of a deadlock? The query looks...
    Posted to Forum by plauten on 07-01-2008
  • Sql server Interview Questions

    Dear members, we provide a solution of bugs related to sql server along with study material and interview preparation of SQL server. click below link to get your solution http://mssqlinterview.blogspot.com/
    Posted to Forum by jmaneesh on 06-23-2008
  • How to turn off deadlock detection in MSSQL2000

    Hi, MSSQL2000 has such a feature that it detects deadlocks and kills one of the transactions which take part in the deadlock. I would like to turn off this feature (for debugging purposes), i.e. make the server not to terminate these transactions (i.e. block forever). Is there a flag/setting in the DB...
    Posted to Forum by plauten on 06-18-2008
  • Performance issue

    I have 2 identical Hardware servers. They were bot purchased and set up the same exact way. They are HP DL 580 G5, 64-bit EM64t/x64 with 16 CPU's running at 2.9GHz with 64 GB RAM. Both have SQL Server 2005 installed. SQL Server has a max memory setting of 52GB. Both servers have a database called...
    Posted to Forum by dgagne on 06-09-2008
  • performance in SQL server 2005

    I have complished a online management information system . but it Jeremy goes to be online in IE with no reason. I must restart my web server for reusing it.please tell me reasons.
    Posted to Forum by richardjin on 01-10-2008
  • Re: Query time out with sql server

    Samkry, These events in Profiler are what you need: Stored Procedures and select the SP:Recompile. The a long execution time for a stored procedure does not necessarily mean that it is recompiling. Thank you, The MSSQLTips.com Team
    Posted to Forum by admin on 11-10-2007
Page 1 of 1 (10 items)