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

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

As it states on the subject line this is an error that would cause when the system is trying to load assembly due to the permissions, the second part of the subject also needs consideration that server may be running out of resources & security issue. Msg 10314, Level 16, State 11, Line 2 An error...

In response to the SQL Server 2008 R2 CTP post I have had flurry of emails asking what more they can learn on 'What's New' compared to the existing SQL Server 2008 RTM which has celebrated its first birtday! As a general recommendation I always recommend to download the latest update of SQL...

Replication will be very handy to distribute the load of application when you have large scale of data management, as it evolved from SQL Server 6.0 version the transactional replication is first baby that was primarily used to support reporting applications. The primary resource of replication satisfies...

The error on the subject line is not a good sign when you have the mammoth task of moving SQL Server system databases, I would agree that the task of system databases migration is not a day-to-day task and you must have practised the required steps. For the sake of clarifications the complete error messages...

In continuation to SQL_Server_2008-ServicePack1_CTP release information it is official that SQL Server 2008 Service Pack 1 (SP1) is now available. You can use these packages to upgrade any SQL Server 2008 edition. If you have been involved in SQL 2008 SP1 CTP within your environment then nothing new...

What is your biggest challenge when you need to upgrade a SQL Server 2008? Do you have a clear process of migrating non-SQL Server databases to SQL Server? Whatever is the reason or need to install SQL Server 2008 you must review the installation requirements, system configuration checks and more important...

Policy Based Management (PBM) is an effective system for DBAs to manage one or more instances of SQL Server. Just to give a brief overview of what it consists, it consists 3 components: Policy management for Administrators to create policies Explicit administration for Administrators to select multiple...

In many case within the forums and newsgroups I still see many questions from the users asking about SSIS (SQL Serve Integration Services) and here few bits I'm covering on basics on this important service in SQL Server arena. SSIS is a key part of SQL Server that will help the user to manage data...