Welcome to Romanian SQL Server User Group Sign in | Join | Help

Browse by Tags

All Tags » Performance   (RSS)

Speaking at Portland SQL Server User Group this Thursday

It's gotten around to the week of the Portland, Oregon, SQL Server User Group meeting. And there's not only going to be a holiday dinner, but I've volenteered to speak again. This time, it's about parameterization and autoparameterization Read More...
Posted 5 decembrie 2011 09:43 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Speaking at Portland, OR, User Group in December

Speaking at a user group is a bit different from speaking at a conference or other event. Because you know the folks there personally (hi Ken, Chris, and all ;-), you can ask around and "do requests", rather than just do what's interesting Read More...
Posted 4 noiembrie 2011 09:54 from Bob Beauchemin's Blog | (Comments Off)
Filed under: ,

Understanding Hash, Sort and Exchange Spill events

Certain SQL Server query execution operations are calibrated to perform best by using a (somewhat) large amount of memory as intermediate storage. The Query Optimizer will choose a plan and estimate the cost based on these operators using this memory Read More...
Posted 19 octombrie 2011 22:28 from rusanu.com | (Comments Off)

LOTS of New Goodies in SQL Server Denali Query Plans

After the last post on new warnings in SQL Server Denali Showplan , just for the fun of it, I had a look at the XML version of the showplan. And saw some fairly amazing new things I hadn't noticed before. Everyone's been looking into the new "Batch Read More...
Posted 27 septembrie 2011 19:48 from Bob Beauchemin's Blog | (Comments Off)

Additional Warnings in SQL Server Denali Query Plans

Sort and hash warnings can be found using SQL Server profiler, but they don't appear in query plans like "Columns With No Statstics" warnings in SQL Server 2008 R2 and below. In SQL Server Denali, they DO appear in query plans. No profiler Read More...
Posted 27 septembrie 2011 18:31 from Bob Beauchemin's Blog | (Comments Off)

Download and Upload images from SQL Server via ASP.Net MVC

A frequent question that pops up on discussion forums is how to serve an image that is stored in a SQL Server table from an ASP.Net application. Unfortunately the answer is almost always wrong, as the prevalent solution involves copying the entire image Read More...
Posted 29 decembrie 2010 08:19 from rusanu.com | (Comments Off)

The Bizzaro Guide to SQL Server Performance

Some say performance troubleshooting is a difficult science that blends just the right amount of patience, knowledge and experience. But I say forget all that, a few bullet points can get you a long way in fixing any problem you encounter. Is more important Read More...
Posted 31 martie 2010 11:28 from rusanu.com | (Comments Off)

Spring 2010 SQLConnections

In just over a week, I'm headed out to Las Vegas for SQLConnections. I'm really looking forward to presenting on the topics I'm doing there, but especially excited about the response to my post-conference workshop on writing data access code Read More...
Posted 31 martie 2010 11:23 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Performance comparison of varchar(max) vs. varchar(N)

The question of comparing the MAX types (VARCHAR, NVARCHAR, VARBINARY) with their non-max counterparts is often asked, but the answer usually gravitate around the storage differences. But I’d like to address the point that these types have inherent, Read More...
Posted 23 martie 2010 06:03 from rusanu.com | (Comments Off)

Dealing with Large Queues

On a project I’m currently involved with we have to handle a constant influx of audit messages for processing. The messages come from about 50 SQL Express instances located in data centers around the globe, delivered via Service Broker into a processing Read More...
Posted 9 martie 2010 10:10 from rusanu.com | (Comments Off)

Latest column on data access and perf available

My latest MSDN column is available in the August issue and called "How Data Access Affects Performance". It was inspired by a problem that one of my DBA friends noticed in the database that could only be fixed by changing the data access code. Read More...
Posted 28 iulie 2009 08:40 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Fix slow application startup due to code sign validation

Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/07/24/fix-slow-application-startup-due-to-code-sign-validation/  Sometimes you are faced with applications that seem to take ages to start up. Usually they freeze Read More...
Posted 24 iulie 2009 21:18 from rusanu.com | (Comments Off)

Spatial Indexes and ANSI JOIN - ON syntax

During a talk about spatial indexes and performance last week, I was surprised by a question about using ANSI-92 JOIN - ON syntax in spatial queries. I'd coded: SELECT * FROM geonames.dbo.geonames g JOIN Sample_USA.dbo.Counties c ON g.GEOG.STIntersects(c.geog) Read More...
Posted 20 iulie 2009 10:51 from Bob Beauchemin's Blog | (Comments Off)

How to ensure your spatial index is being used

I've answered quite a few questions lately about how to make sure that your spatial index is being used. Use of a spatial index with a large or complex spatial dataset can mean the difference between a query that takes minutes to execute and subsecond Read More...
Posted 25 aprilie 2009 18:02 from Bob Beauchemin's Blog | (Comments Off)