SqlServer-QA.net

SSMS - useful tool for a SQL Server DBA and user to manage their work in SQL Server. This tool has been fine tuned since the RTM release of SQL 2005 since Nov.2005 and you may be aware using this tool you can manage SQL 2005 and 2000 instances without any issues. IF you are on a Windows domain network then for the day-today work you must use ...

Updates to system catalogs are not allowed - a big subject and nothing but opening door to trouble by allowing direct updates or modifications to system tables in SQL Server 2005. If I remember correctly since the days of SQL 6.5 version Microsoft has been discouraging udpates to system tables even though the provision has been enabled. Since ...

SQL Server 2005 table partitioning provides many improvements in terms of manageability and availability.   This is an enhancement on taking the performance advantage on the aspects of manageability by allowing improvements to metadata only switch-in and switch-out of a partition of data. Regardless of whether you are using ...