Browse by Tags

Scream if you want to go faster

My session for 24hrs of pass on High Performance functions will be starting at 11:00 GMT thats migdnight for folks in the UK. To attend follow this link https://www.livemeeting.com/cc/8000181573/join?id=N5Q8S7&role=attend&pw=d2%28_KmN3r The rest of the sessions can be found here http://www.sqlpass...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, May 19 2010
Have you really fixed that problem?

The day before yesterday I saw our main live server's CPU go up to constantly 100% with just the occasional short drop to a lower level. The exact opposite of what you'd want to see. We're log shipping every 15 minutes and part of that involves calling WinRAR to compress the log backups before...

Posted to DavidWimbush (Weblog) by DavidWimbush on Thu, Mar 18 2010
User defined function performance is awful, Micorosft please sort this out

User defined functions looked like something great when they were introduced in SQL 2005. They are a very logical step to make more code reuseable by wrapping common code in functions. It is an approach that is in development 101 and something everyone does and looks to doing. So what is the problem...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Jan 14 2010
A significant part of sql server process memory has been paged out

Do you have the following occuring on your SQL Server system. If so it is likely you are running SQL Server 2005 or SQL Server 2008 Standard edition on x64 hardware. It will be causing you serious performance issues when it occurs, as all your database pages will be removed from memory and thus SQL will...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Mar 10 2009
How to speed up partition merging

The key to performance with partition management is to deal with empty partitions. That way all you have is meta data changes and no data has to be copied. We recently encountered a situation where we had two partitions and wanted to merge them. In a merge you have 3 boundaries the left one, the middle...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Jul 31 2007
SQL Server The Truth - Rebuilding a clustered index does not rebuild the non clustered indexes

It used to be fact that the leaf page of a non-clustered index pointed to the row for the page, because it pointed to the file, page and row if the file or page of the row changed the nonclustered index had to be updated. Now however the non-clustered index has the Unique Clustering Key value for the...

Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Jul 20 2007
How many indexes do you have that aren't used?

If you run this sql on a sql 2005 box then you will see which indexes aren't used in queries compared with the number of times they are updated. select object_name ( s . object_id ) , * from sys.dm_db_index_usage_stats s join sys.indexes i on i . index_id = s . index_id and s . object_id = i . object_id...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, May 16 2007
SSIS - Parallel processing

I remember seeing a very early CTP of Yukon and the new DTS. I was very exceited to see a parallel property on the loop container which would allow the contents of the container to be executed in parallel. If you've used the RTM on Yukon you will know that there is no such property. Unfortunately...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, May 15 2007
What is the cost of a query? Is it a beard?

I used to work on a project where we discussed what exactly the cost of a query was. You know that figured shown in execution plans. I knew it was used to age plans in a cache but not sure what unit it actually was. One of the guys on the project (Mike I think) decided to call them "Beards"...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Apr 4 2007
Developer Day 4

If you've never been to a developer day then your missing a great day. The day is split into a number of tracks with 5 sessions in each track. All the sessions are given by non-microsoft people and are generally based on real life experience, which makes the content great. I'll be speaking this...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Nov 23 2006

Page 1 of 4 (40 items) 1 2 3 4 Next >