THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Performance   (RSS)
Showing page 7 of 20 (194 total posts)
  • Everybody Needs a Test Harness

    When you're developing new Transact-SQL code or modifying some existing code, do you just launch directly into programming? I know that I did just that, for years. It wasn't until I was trying to performance tune some existing code that I realized I hadn't actually taken caching of data and execution plans into account. So all those modified ...
    Posted to Kevin Kline (Weblog) by KKline on October 31, 2011
  • TPC-H Benchmarks - Westmere-EX versus RISC

    There has been relatively litle activity in TPC Benchmarks recently with the exception of the raft of Dell TPC-H results with Exa Solutions. It could be that systems today are so powerful that few people feel the need for benchmarks. IBM published an 8-way Xeon E7 (Westmere-EX) TPC-E result of 4593 in August, slightly higher than the Fujitsu ...
    Posted to Joe Chang (Weblog) by jchang on October 10, 2011
  • Consumer SSDs with SQL Server

    Over the last two years, I have stood up several proof-of-concept (POC) database server systems with consumer grade SSD storage at cost $2-4K per TB. Of course production servers are on enterprise class SSD, Fusion-IO and others, typically $25K+ per TB. (There are some special situations where it is viable to deploy a pair ...
    Posted to Joe Chang (Weblog) by jchang on September 16, 2011
  • Speaking in Raleigh NC 9-20-2011

      If you are in the area I will be speaking at the Triangle SQL Server Users Group meeting on Tuesday the 20th of September 2011. The session is on TempDB Best Practices and all of the details for the topic, directions etc. can be found here.  Be sure to register so they have enough food. Thanks and hope to see you all there, Andy
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on September 15, 2011
  • Can a SELECT query cause page splits?

    Books Online has this to say about page splits: When a new row is added to a full index page, the Database Engine moves approximately half the rows to a new page to make room for the new row.  This reorganization is known as a page split.  A page split makes room for new records, but can take time to perform and is a resource ...
    Posted to Page Free Space (Weblog) by Paul White on August 29, 2011
  • Speaking at the Charlotte Users Group

      I will be giving a presentation in between Earthquakes and Hurricanes in Charlotte NC. this Wednesday the 31st of August on Understanding Indexes in SQL Server 2008. If you are in the area please drop by and say hello. You can find out more information and register for the event here. Andy
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on August 26, 2011
  • Chasing the ISV, or, “That code makes my teeth hurt.” T-SQL Tuesday (ish) #21

    This month’s T-SQL Tuesday – a blog party dreamed up by’s Adam Machanic ( blog | @AdamMachanic ) – is about that code we’ve all written that we don’t really like to think about too often. You know the stuff. I can’t help but imagine the next poor guy who comes across some of mine and thinks, “What the … How in … Seriously?” I have two ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on August 10, 2011
  • SQL Server, Seeks, and Binary Search

    The following table summarizes the results from my last two blog entries, showing the CPU time used when performing 5 million clustered index seeks: In test 1, making the clustered index unique improved performance by around 40%. In test 2, making the same change reduced performance by around 70% (on 64-bit systems – more on that later).  ...
    Posted to Page Free Space (Weblog) by Paul White on August 8, 2011
  • OUTPUT clause and windowing functions

    A few days ago I was asked a question how to remove duplicates from a table. As usually in such cases, the duplicate values were related only to several columns, not all of them. So classical approach, to copy distinct data into temp table, truncate the table with duplicates and then copy the data back wouldn’t work. In such cases I find one of ...
    Posted to Piotr Rodak (Weblog) by on July 31, 2011
  • Microsoft Windows Platforms Blog Watch

    Remote Desktop Services Component Architecture Poster Grab your own poster! A visual guide to key Remote Desktop Services technologies in Windows Server 2008R2     Virtually Free Get the latest update rollup package for the Hyper-V role in Windows Server 2008 R2 and be sure to bookmark the Windows Virtualization ...
    Posted to Kevin Kline (Weblog) by KKline on July 20, 2011
« First ... < Previous 5 6 7 8 9 Next > ... Last »
Privacy Statement