SqlServer-QA.net

I feel this type of contest by Microsoft will make this (2008) SQL Server release as a best release as more and more users will be interested to join the SQL Server 2008 February CTP Bug Bash Contest that will gain chance to win XBOX. These are the OfficialRules that govern how the Microsoft SQL Server February CTP Bug Bash ...

Business Intelligence (BI) - is the new term from Microsoft for all Data Warehousing & Data Mining requirement since the SQL Server 2005 version is released. Say many organization face challenges with the Data Explode, this BI offers management and development tools for IT department and Business segment within your organization with ...

Windows Vista SP1 RC is released on 05th December to the Beta Testers on the Microsoft-Connect and on 06th December it is available via MSDN and TechNet subscribers.  Few things if you want to know about Vista SP1 RC refer to the following notes from Microsoft: ·         Microsoft are ...

Since the release of SQL Server 2005 Service Pack 2, Microsoft development team has released various builds that are classed as Cumulative Updates. Also we blogged on this site - CumulativeUpdate4 & ...

Continuing on the MAX WORKER THREADS topic from ThisBlog I have been asked about method of calculating the amount of system resources that will be used when the setting is increased to 500 from 255 (default). Well, as one of the best practices you must test the implications and usage in hiking such a value that will affect the whole server ...

Whenever a service pack is released it will be available for 32-bit and 64-bit that also includes for SQL Express 2005 edition too, as it was for MSDE earlier. Since last year (I think) Microsoft Development team has adopted a standard in naming schema for all service pack updates aka they call it now as a software update packages for ...

You might have come across on the web resources that setting the disk to a 64k cluster size (8 * 8KB pages) might achieve the performance. But have you wondered will this really boost the disk performance, see in what scenario such as lots of reads and writes from the database to disk. In this case take help of SYSMON (PERFMON) for Avg. Disk ...

Within your SQL Server environment there are few simple steps you can take up in order to gain performance to a level, for instance when configuring a SQL Server that will only contain a few gigabytes (GB) of data and not sustain heavy read nor write activity, it is not as important to be concerned with the subject of disk I/O and balancing of SQL ...