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 MoreSQLAuthority 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 MoreSQLAuthority News – USB Drive Fails to Copy Large File
I am currently traveling on a month-long training assignment for Business Intelligence. For demonstration purposes, I use Virtual PC files and hands-on lab examples for attendees of the training. The size of my VPC file is about 15 GB. Initially, I copy this file to a USB Drive and then…
Read MoreSQL SERVER – Reason for SQL Server Agent Starting Before SQL Server Engine Service
Nakul, a dedicated member of the Gandhinagar SQL Server User Group, recently emailed me with a very interesting, but quick question. He asked me why the SQL Server Agent starts before SQL Server Engine does? He made the very valid point that as the SQL Server Engine is the core…
Read More