THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Performance   (RSS)
Showing page 5 of 27 (261 total posts)
  • How often do you rebuild your heaps?

    Never? You are not alone. None of the maintenance solutions I use includes functionality to rebuild a heap, and that includes Maintanance Plans and Ola Hallengren's maintenance solution. ''So why would you want to rebuild a heap, when it isn't sorted in the first place?'', you ask. The answer is to get rid of Forwarding Pointers, and these can ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 6, 2014
  • Setting max server memory

    If there is one server setting that is close to universal to configure, then it is probably the ''max server memory'' setting. The setting is documented here. There are plenty of articles out there on this subject. The purpose for this article is for me to have somewhere to point when I get the question: ''What value should I set this to?''. I ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 6, 2014
  • Fake statistics, and how to get rid of them

    There are two ways to test how your queries behave on huge amounts of data. The simple option is to actually use them on huge amounts of data – but where do you get that if you have no access to the production database, and how do you store it if you happen not to have a multi-terabyte storage array sitting in your basement? So here’s the second ...
  • Updated File & Wait Statistics Procedures

              Please note that I have a newer version of these procedures that you can find herehttp://sqlblog.com/blogs/andrew_kelly/archive/2015/09/02/revised-file-wait-statistics-procedures.aspx .  For many years I have been using a set of stored procedures to capture and report on both ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on February 13, 2014
  • Do you want improved performance?

    Can you survive a few lost transactions if your server does a ''hard shutdown''? If so, check out SQL Server 2014 and ''Delayed Durability''. A cornerstone in SQL Server's transaction handling has up until 2014 been ''durability'' for a committed transaction. Durability is by the way the ''D'' in the ACID acronym: Atomicity, Consistency, ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on February 13, 2014
  • One Preparation that makes SSMS Crash Dumps Easy to Survive

     Uh oh!So you're plugging along in SQL Server Management Studio (SSMS) when it suddenly goes belly up. Now you're staring at various dialog boxes telling you that SSMS crashed. Usually the first dialog box you get will ask you if you'd like to close OR the program. If you choose to close the program, you'll be presented with the opportunity ...
    Posted to Kevin Kline (Weblog) by KKline on February 10, 2014
  • Parameterization and filtered indexes (part 2)

    In my previous post, I demonstrated how the presence of a filtered index can get in the way of successful parameterization, possibly resulting in too much query compilations and procedure cache bloat. I suggest reading that first, because I will go straight where I left off.   Use the Force, Luke   If you read the previous post very ...
  • Understanding Execution Plans

    To me, it feels as if 2014 is a long time away. But it isn’t. Sinterklaas has already dropped off his presents and is probably already back in his castle in Spain. Christmas is almost upon us. And before we know it, we’ll be washing oliebollen down with Champagne. That also means that I need to get cracking on preparing my precon seminar on ...
  • Updateable columnstore index gotchas

    SQL Server 2014 introduces updateable nonclustered and clustered columnstore indexes. When new data is inserted, it goes first to deltastore where background process divides it into row groups, indexes and compresses. Indexing progress can be observed via sys.column_store_row_groups DMV. According to BOL, row groups in deltastore can be in one of ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on December 1, 2013
  • SQLRally and SQLRally - Session material

    I had a great week last week. First at SQLRally Nordic, in Stockholm, where I presented a session on how improvements to the OVER clause can help you simplify queries in SQL Server 2012 enormously. And then I continued straight on into SQLRally Amsterdam, where I delivered a session on the performance implications of using user-defined functions ...
« First ... < Previous 3 4 5 6 7 Next > ... Last »
Privacy Statement