SQL Server Express is one of the most valuable products of Microsoft. Very often, I face many questions with regard to SQL Server Express. Today, we will be covering some of the most commonly asked questions.
SQLAuthority News – Business Intelligence Training Roadshow August September 2009
UPDATE : This is FREE training. I quite often receive request from readers and expert from all over the world if I do any training for SQL Server. Currently I am on Tour of 8 different stats of India and will be training on Business Intelligence Boot Camp. Here is…
Read MoreSQL SERVER – Index Seek vs. Index Scan – Diffefence and Usage – A Simple Note
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 More