Browse by Tags

All Tags » TSQL » Performance (RSS)

Performance Tuning and Query Optimisation–SQLBits Training Day

I will be doing a training day at SQLbits in April on Performance Tuning and Query Optimisation. This is the outline for the day. Its going to be an intense day, I look forward to seeing you there. To register go to http://www. sqlbits .com/information...

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 with SQL Server.

Well the issue is that ......

...

When is the MAX value not the TOP value

Have a look and try the following statements, and try and think what the expected results are. The key aspect is that the query does not match any rows, no object exists with id = -99 declare @maxValue datetime set @maxValue = '1/1/1900' select...
Posted by simonsabin | 2 comment(s)
Filed under: ,

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...
Posted by simonsabin | with no comments

Performance of formatDateTime SQLCLR function

Following my previous post I have been asked on the performance of the function I wrote. This is an area I am keen to press on people. Any one questioning SQLCLR performance should have come to my launch event. CLR function is slower than built in system...