Welcome to Sign in | Help

Browse by Tags

All Tags » Tutorials   (RSS)
In my previous article How to use columnstore indexes in SQL Server we’ve seen how to create a columnstore index on a table and how certain queries can significantly reduce the IO needed and thus increase in performance by leveraging this new feature. Read More...
Column oriented storage is the data storage of choice for data warehouse and business analysis applications. Column oriented storage allows for a high data compression rate and as such it can increase processing speed primarily by reducing the IO needs. Read More...
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...
Query Notifications is the SQL Server feature that allows a client to subscribe to notifications that are sent when data in the database changes irrelevant of how that change occurs. I have talked before about how Query Notifications works in the article Read More...
SQL Server Database Mirroring uses an encrypted connection to ship the data between the principal and the mirror. By default RC4 encryption is enabled and used. The endpoint can be configured to use AES encryption instead, or no encryption. The overhead Read More...
A very common question asked on all programming forums is how to implement queues based on database tables. This is not a trivial question actually. Implementing a queue backed by a table is notoriously difficult, error prone and susceptible to deadlocks. Read More...
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...
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...
The SMO libraries contain an enum for the DBCC commands: DbccCommand. But there is little explanation in the MSDN documentation what those commands are. I had a recent discussion with a developer who, understandably, expected a little cleaner explanation Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/09/13/on-sql-server-boolean-operator-short-circuit/  Recently I had several discussions all circling around the short-circuit of boolean expressions in Transact-SQL Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/08/18/passing-parameters-to-a-background-procedure/  I have posted previously an example how to invoke a procedure asynchronously using service Broker activation. Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/05/16/readwrite-deadlock/  How does a simple SELECT deadlock with an UPDATE? Surprisingly, they can deadlock even on well tuned systems that does not do spurious Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/05/15/version-control-and-your-database/  I am still amazed when I walk into a development shop and I ask for their application database script and they offer Read More...
Copyright Remus Rusanu 2008. Visit the original article at http://rusanu.com/2008/11/26/replacing-service-certificates-that-are-near-expiration/  Service Broker services use certificates for authenticating message origin and for encrypting messages. Read More...
Copyright Remus Rusanu 2008. Visit the original article at http://rusanu.com/2008/11/04/conversations-authentication/  I have covered before how certificate based authentication works for endpoints. I think is only fair to have a similar article Read More...