(Jeremy Kadlec) Who ever imagined Microsoft would be offering a free version of its enterprise database management platform? From the original SQL Server 2000 MSDE to the current SQL Server 2005 Express edition, we never before had a fully featured Management Studio to build and deploy SQL Server da

Lock escalation is the process of converting many fine-grained locks (such as row or page locks) into table locks. Microsoft SQL Server dynamically determines when to perform lock escalation. When making this decision, SQL Server takes into account the number of locks that are held on a particular s

(asif.blog) I will start with a question here. How many of you had chance to interact with Employee table from sample database Northwind? There you go… I can imagine countless hands in air, and why not it is one of the standard databases comes with both Access and SQL server. All right, are we

(Mike Gunderloy) If you’ve been developing with SQL Server for any length of time, you’re undoubtedly used to referring to objects with four-part identifiers: [[[server.][database].][schema_name].]object_name

(Stephen Swoyer) Unless you’ve been off siesta-ing in a data warehouse appliance, you probably know that Microsoft Corp. last week dropped a bombshell on the business intelligence (BI) industry. Redmond outlined an Office-focused BI and performance management (PM) strategy that—for the first time—ca

(Kevin Beaver) Before the days of SQL Server 2005, you could encrypt passwords, data in transit and, well, just about everything except the one thing that’s most important: data at rest. These older encryption features also tended to be cumbersome, which prohibited developers and DBAs from taking ad

(Shawn Wildermuth) As database developers, many of us have had to dip our feet into the wide ocean of XML.

(Satya Jayanty) How do you know when a table is fragmented? –Poor query performance over time. –More disk activity. –Poor cache utilization. –Verify the I/O of a query. –Verify scan density in SQL 2000 using DBCC SHOWCONTIG and in SQL 2005 using the dynamic management view sys.dm_db_

(Arthur Fuller) SQL Server 2005 Express Edition is a freely available version of SQL Server that is included in several Microsoft products. However, the version bundled in offerings such as Visual Studio 2005 lacks a critical component: Management Studio (which is the equivalent of Enterprise Manage

(Jagadish Chaterjee) This is the second part of a tutorial focusing on common table expressions in SQL Server 2005. In the previous article, I explained non-recursive CTEs. Therefore, in this article, I shall mainly focus on recursive CTEs in SQL Server 2005.