Best Practices are good enough to follow, but simply do not read and digest. Try to implement them within your environment to keep up the performance. Similary there are many things involved within the SQL Server 2005 Analysis Services such as MDX queries, data mining etc. For any sort of performance analysis exercise you must identify the ...

Though the message specifies as an informational message only and no user action is required, you should take some action to avoid current behaviour of databases within your environment. Also check whether you have enabled the AUTO_CLOSE property for any of the databases on that SQL Server instance, on the down side it is not recommended in ...

PARALLELISM is a close friend of DBA where you get to see it as a common occurence in the multi-processor server environment and during such performance issues you can also investigate whether a parallel plan is in use. For instance If a particular query is slow when it is using a parallel plan, you can try forcing a non-parallel plan by using the ...

When it comes to resolving table fragmentation, the basic checkout you perform is to run DBCC INDEXDEFRAG or even run DBCC DBREINDEX statements. As per the default configuraiton SQL Database Engine allocates a new extent to an allocation unit only when it cannot quickly find a page in an existing extent with sufficient space to hold the row being ...

You may be aware the DML and DDL triggers can be nested up to 32 levels, because any reference to such trigger code counts as one-level in the nesting limit. Even though it is possible to control whether AFTER triggers can be nested through the nested triggers server configuration option. So how it can be escaped using CLR and how procedural and ...

Its a general assumption that whenever performance is degraded, the finger will be pointed to SQL Server, pretty easy eh!? If you look at any of the SQL Server related forums then 3 in 10 questions asks same question and nothing but shove blame on SQL Server. It is always better to be proactive than reactive, when it comes to identifying and ...

You may be aware that using SSL communications a HTTP server can have encryption for us, in this regard certificates must be authorized for server authentication. Microsoft recommends that you can do this by either obtaining an SSL certificate from a certificate-issuing authority, such as Verisign, or if for testing purposes, by using tools to ...

We have had a request from one of the solutions company stating they have to mirror 15 SQL Servers that are dispersed across the European locations to a central location. For this they have deployed the X64 environment for operating system and SQL Server application too. So now the question is will there be any limit on the number of databases to ...

No doubt that as compare to previous version the current SQL Server 2005 provides more new language constructs and primitives for the T-SQL language than can be utilized. Still there are many out there not entirely ready to upgrade from SQL Server 2000 to 2005. In this case you can take few advantages of SQL 2005 by keeping the user databases in ...

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: The performance of a query that performs an insert operation or an update operation is much ...