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