In the database world Performance and Scalability goes in line like a railway track! In parallel SQLBits conferences are more popular in UK and Europe, where you get real-world content to learn and share. For the year 2010 it is SQLBits - The 6th Sets our latest, and if we may be so bold, our greatest...

Here is the news for Scottish Area SQL Server user group members and new comers in Scotland that are enthusiastic to learn tips & tricks to tackle your day to day problems in SQL Server arena. Time Starts (UK time) at 18:00 , Finishes 21:00 Cost Free Organiser UK SQL Server User Group Address Microsoft...

To followup from The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure blog post, here are few findings that I would like to share. When you see that SQL Server instance throws the error as per above blog post, the amount...

A typical error occurred when a simple SSIS package has been executed to export 500 rows to another SQL instance, not once atleast 3 times! More information on error text from event viewer that has been generated by the 'service; The buffer manager failed a memory allocation call for 20485670 bytes...

Every now and then I see this big question from SQL Server users that when to use a stored procedure? Well there is a second part to this question as well, think about caching of such stored procedures There is no such database management software that can guarentee you flawless query execution over...

Every database object will have a sort of dependency between them, such as a stored procedure to run few queries against a table. Similar to this whenever a SP or query is executed then a compiled plan will be generated by the SQL query optimizer, to note about there are two main types of plans in the...

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...

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...