join the MSSQLTips community

MSSQLTips.com - your daily source for SQL Server tips

Google
 
Web mssqltips.com

 
Browse by Tags - MSSQLTips

MSSQLTips

MSSQLTips.com - your daily source for SQL Server tips
Welcome to MSSQLTips Sign in | Join | Help
in Search

Browse by Tags

All Tags » performance (RSS)
  • Problem with temp database in sql 2005

    hi everybody, I am facing one problem while executing the query the size of temp database increasing at rapid speed and the size of data file become 15 gb from 500 mb and then it stuck as the space of c drive get full. before that query was running gud but it was taking only 5 min. i tried the tuning...
    Posted to Forum by akshayt on 03-15-2009
  • List of my Login

    How I can get a list of all my login (User login - login with name which not start with prefix like : ## , $ ,sa,BUILTIN ... ) throw SQL code. Thank you .
    Posted to Forum by petko on 01-17-2009
  • Find a number between the given ranges of number / Find a row which has range of given number

    I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: - In first row the value...
    Posted to Forum by bsethi24 on 12-05-2008
  • SQL Server Club: September 2008

    I was fortunate enough to have been invited to speak again at the SQL Server Club, which is a Quest sponsored event, focused on Enterprise-class SQL Server topics. The focus of this event was SQL Server Performance and it was thoroughly enjoyable presenting sessions alongside all round nice guy and SQL...
    Posted to Weblog by Charley Hanania on 10-21-2008
  • How to Improve performance on partion View?

    How to Improve performance on partion View? I have partition view that will fetch data by having union all to 9 database tables. All 9 databases have same table and schema structure on same instance. At the background, this tables keep loading new data for every 1 min to all 9 databases through...
    Posted to Forum by sbhaygude on 09-26-2008
  • repeated missing indexes from performance dashboard

    Hi. I'm kinda new to the index world, but I ran the Dashboard report on my database so I can improve the efficiency and the list of missing indexes are listed below. My questions are, why are some repeated, and can any of them be combined (like [dbo].[PlantEquipmentSignal] ([EquipID]) [dbo].[PlantEquipmentSignal...
    Posted to Forum by fldavem on 09-11-2008
  • 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
Page 1 of 2 (16 items) 1 2 Next >