in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » SQL » Performance (RSS)

Browse by Tags

  • To cluster of not

    Tony's blogged about the use of heaps http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/06/24/row-fragmentation-hopscotch-heap-v-clustered-and-io-cost.aspx . Whilst this highlights data on a page being out of sequence and thus yoyoing when you scan the data, it doesn't mean you should always...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Jun 26 2007
  • Are you allowed to be sizeist in the database world

    Well even if your not, one of my real bug bears is fat tables. These aren't large tables they are fat tables, wide ones with lots of columns or large data types. The reason this gets is is people develop databases with 10s of rows in them. Then end up with millions of rows in them in a live environment...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, May 25 2006
  • Performance of MAX trick

    Jamie posted a comment to by post about the trick for finding a maximum value in a set of results. Stating that the CASE statement solution was significantly faster. Being a synic I didn't believe him so tried it out for myself The following are the two sets of code, and below that is a script to populate...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, May 16 2006
  • Increase the performance of updates by 1000

    Following on from my previous post on varchar(max) for which the consensus was that one shouldn't use varchar(max) everywhere, I have found this great function that allows you to update a varchar(max) column with great performance gain. The function is called Write and is used in an update statement...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Mar 2 2006
  • Microsoft.com SQL Server architecture

    I was sent a link recently on the Microsoft.com SQL Aerver Architecture , this is really interesting and follows on from a interview I read last year with Jim Gray on channel9 that talked about terraserver using a white box solution rather than clustering. The key here is that scaling out a clustered...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Feb 14 2006
  • Deleting/archiving data in SQL Server 2005

    A delete can now use TOP i.e. DELETE TOP (2000) FROM MyBigTableWHERE someCondition = true ORDER BY Dateolumn ASC Michael Campbell has blogged about removing data from a table in chunks http://sqladvice.com/blogs/repeatableread/archive/2005/09/20/12795.aspx . This can be simplified even further in SQL...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Nov 10 2005
Page 1 of 1 (6 items)
Powered by Community Server (Commercial Edition), by Telligent Systems