SQL Server query optimization and keepup of performance is not a black-art, it can be achieved in a fair manner if you treat your queries with plans with a are reused or recompiled plans that can help you design well-performing applications. There are ways to add a plan or data to the SQL Server cache...

Government of India has started the process & project of implementing the Unique Identification (UID) project for whole of India. For those who don’t know what it is find more about this initiative and see this PDF attachment too. Another face and lead of this project is Mr. Nandan Nilekani, CEO...

Here is the information about Windows Operating System support life cycle that you need to concentrate: With the end of support (EOS) coming for several products, moving to Windows 7 and utilizing the many features built into the product can help you achieve a more secure and compliant platform for your...

Here is the advisory guidelines email from Microsoft Security that I would like to share: Microsoft is aware of public exploit code released that impacts customers using Internet Explorer 6. Customers using Internet Explorer 8 are not affected by currently known attacks and exploits due to the improved...

It is a common criteria that using Dynamic Management Views (DMVs) you can easily obtain the system & database state on a SQL instance. It may not be easy for a starter DBA to ensure what kind of DMV is used to obtain information on Recent Expensive Queries, if so for you Activity Monitor is the...

Its the time again that you should re-visit your database platform to ensure none of the SQL instances fall within SQL Server 2005 Service Pack2 or SQL Server 2008 RTM editions! It is quite common scenario that few of Enterprises may not ...read more from Service-pack_Support policy blog post....( read...

Whenever you plan or proceed for a SQL Server installation, it requires the following steps: Review installation requirements, installation options, system configuration checks, and security considerations. Run SQL Server Setup to install, upgrade, or migrate to SQL Server. Use SQL Server utilities to...

On the subject line the process to find the answer is not a short one! By design SQL Server engine takes care when the query optimizer generates a query plan, it analyzes what are the best indexes for a particular filter condition. If the best indexes do not exist, the query optimizer generates a suboptimal...

Data is most business-critical for any organization and no doubt that they invest heavily to make data management system more efficient, above all the storage is important piece in the puzzle. Now a days there are no limitation in terms of what kind or type of data you can store in the database, where...