Welcome to Sign in | Join | Help

septembrie 2008 - Posts

In the past year or so, a few installations had begun to experience problems with the SQL Server 2005 security cache (aka TokenAndPermUserStore) growing too large over time. Some manifestations are connection and query timeouts and queries that take a Read More...
A friend of mine was asking about the affect of multi-targeting in Visual Studio 2008 on SQLCLR. For an explanation of how multi-targeting works, reference David Kean's blog entry on Visual Studio 2008 multi-targeting and FXCop. I happened to have an Read More...
Although being able to use a GUI tool like SQL Server Management Studio is a nice feature by itself, it's unusual that fixing something in a GUI makes a feature (that hasn't changed) more useable. The "feature" is defaults on SQLCLR procedure parameters. Read More...
Extended Events is one of my favorite SQL Server 2008 features and I'll be speaking about how to use them for problem diagnosis, at the Portland (Oregon) SQL Server User's Group's September meeting. Check out http://www.pdxvbug.com/pdxuser.asp for details. Read More...
Technorati Tags: Cloud A new SQL Server Data Mining tool is available now for you to use directly from the browser — the Prediction Calculator. The feature (already present in the 2008 version of the Data Mining Add-ins) is a scorecard generator. Read More...
Posted 16 septembrie 2008 09:56 from DM(X) | (Comments Off)
Filed under:
Copyright Remus Rusanu 2008. Visit the original article at http://rusanu.com/2008/09/14/wcf-channel-for-ssb/  There is an unofficial WCF channel for SQL Service Broker posted by David Browne on www.codeplex.com/ssbwcf. To quote from the project Read More...
Copyright Remus Rusanu 2008. Visit the original article at http://rusanu.com/2008/09/09/quest-service-broker-admin-feedback/  While looking at the Google Analytics report for this very blog I found a new refferal site: http://questservicebroker.blogspot.com/. Read More...
After reading Isaac's recent blog posting about spatial queries and index hinting , I thought I might add some information based on a query I was working with this week. Sometimes if you have a query that's too syntactically complex, hinting won't work. Read More...