January 2008 - Posts
As you are aware that SYSMON (PERFMON) provides very useful counters to analyze the system performance or to schedule a historical growth of your system usage. From the changes (upgrade) to the Operating System and SQL Server we now have new set of SQL
Read More...
One of the best features you have in the SQL Server is to create database data file (additional) on fly without having a slow performance affect on existing connections. But think about how SQL Server manages to use server threads for the data file that
Read More...
Here is another new year gift from Microsoft for the SQL Server users, specifically for 2005 version - release of SQL Server 2005 Best Practices Analyzer (January 2008). BPA's job is to gather data from Windows and SQL Server configuration settings. There
Read More...
You all know that it is a best practice to use the schema qualified tables or views for the better management and performance (sometimes). As the Best Practices Analyzer tool which will be a part of SQL engine from 2008 version onwards confirms that this
Read More...
Upgrading a SQL Server database should be straight-forward, when you haven't got much of constraints on the application code. In this regard we have blogged previously such as UpgradeTags posts. Here in this post I would like to go with few FAQs that
Read More...
Interesting and usefull cross-blogs from a fellow MVP on stored-procedures, transactional replication: Parse delimited string in a Stored procedure Exporting blank SRS report to excel does not render the headers Setting up Transactional Replication from
Read More...
Linked Server errors, such as between SQL Server 2000 and 2005 versions are quite common in DBA-day life. When it goes wrong I would always refer (myself) and others to review HowDoI-PreventLinkedServerIssues resource from ASPFAQ site. Also the usual
Read More...
An interesting cross-post from SSP Blog - read thisblog for more information.
Read More...
When you are setting up SQL Server cluster you should think about security privileges that is required for the Cluster Administrator account and SQL Server services account. Do not attempt to use same account for both the serivces, as it will be single
Read More...
Few times I get such error Snap-in failed with a long CLSID string mentioned in the subject above. On this client machine previously I have SQL Server 2000 tools and recently installed 2005 version too, instantly error: Snap-in failed to initialize Name
Read More...
Do you cache or not? By default SQL Server cache stores the data & query plan in cache to provide better performance for your queries. Similary caching is also included in SQL Server Reporting Services where this caching can shorten the time required
Read More...
May 25 2007- From the snippet of Tibor Karaszi , SQL Server MVP I have raised a feedback form on Connect.Microsoft website to get newer version (SQL Server 2005) about Index Defragmentation Best practices information. Vote your interest to get newer documentation
Read More...
Had an interesting problem on one of the SANs that will be used to setup a failover clustering installation. The issue error "'There is not enough disk space on the destination disk for the current SQL server data files" and when I have checked relevant
Read More...