In this article we shall examine the two modes of data search and retrieval using indexes- index seek and index scan, and the differences between the two.
SQLAuthority News – SQL Server 2008 Migration White Papers
Quite often I get project when I am asked to migrate different database to SQL Server. Microsoft has excellent white papers written for this series. Guide to Migrating from MySQL to SQL Server 2008 In this migration guide you will learn the differences between the MySQL and SQL Server 2008…
Read MoreSQLAuthority News – Microsoft SQL Server 2008 Books Online
SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008. Books Online includes the following types of information: Setup and upgrade instructions. Information about new features and backward compatibility. Conceptual descriptions of the technologies and…
Read More
SQL SERVER – Get Query Plan Along with Query Text and Execution Count
Quite often, we need to know how many any particular objects have been executed on our server and what their execution plan is. I use the following handy script, which I use when I need to know the details regarding how many times any query has ran on my server along with its execution plan. You can add an additional WHERE condition if you want to learn about any specific object.
SQL SERVER – FIX : ERROR : Cannot open database requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.
This error is quite common and I have received it few times while I was working on a recent consultation project. Cannot open database requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’. This error occurs when you have configured your application with IIS, and…
Read MoreSQLAuthority News – Two Virtual Tech Days Sessions – Watch it Online
Indias premier online technical event is back again with the 6th Edition of Microsoft Virtual TechDays, scheduled to be held between August 19 -21, 2009. During these three days, you will have an opportunity to deep-dive into latest Microsoft Technologies and get a resolution to your most puzzling technical problems…
Read MoreSQLAuthority News – Beyond Relational Interview on SQL Server 2008 Beyond Relational
SQL Server MVP and my personal friend Jacob Sebastian has published my interview on subject of Beyond Relational on his famous site Beyond Relational. Jacob is quite known for his T-SQL challenges as well. If you have not ever tried one, I suggest you give it a try and you…
Read More
SQL SERVER – Measure CPU Pressure – Detect CPU Pressure
The CPU is responsible for not only SQL Server operations but also all the OS tasks related to the CPU. Let us learn about measuring CPU Pressure.Â
SQLAuthority News – Evaluate the Microsoft SQL Server 2008 R2 August Community Technology Preview (CTP)
SQL Server 2008 R2 expands on the value delivered in SQL Server 2008 to help your organization scale with confidence and improve IT and developer efficiency with new and enhanced tools for application and multi-server management, master data services and complex event processing. The new Self Service BI capabilities will…
Read More
SQL SERVER – Introduction to Change Data Capture (CDC) in SQL Server 2008
Simple-Talk.com has published my very first article on their site. This article is introducing Change Data Capture – the new concept introduced in SQL Server 2008. Change Data Capture records INSERTs, UPDATEs, and DELETEs applied to SQL Server tables, and makes a record available of what changed, where, and when, in simple relational ‘change tables’ rather than in an esoteric chopped salad of XML. These change tables contain columns that reflect the column structure of the source table you have chosen to track, along with the metadata needed to understand the changes that have been made.