By Kurt Survance, 03/15/2011
Find out how SQL Server 2008’s spatial data types compare to traditional T-SQL functions when it comes to performing complex geospatial queries.
By Kurt Survance, 02/07/2011
The introduction of CLR may have blurred the line between DBA and developer, but this powerful coding tool offers real advantages over SQL for all roles in a deployment.
By Kurt Survance, 06/23/2010
This article's real-world example might help you start thinking in a set-based way about a common type of problem that has an intuitive procedural solution.
By Kurt Survance, 01/21/2010
Using the Deadlock graph event class lets you easily gather information on SQL Server deadlocks that you can display graphically in SQL Server Profiler or SQL Server Management ...