SqlServer-QA.net

What will be the main challenge for a DBA/User to manage a large Data Warehouse (DW) environment, size does matter and also think about downtime you need to deploy whenever any patches are required. Before that you need to be perfect or well-versed with Data partitioning & Data lifecycle within that DW environment.  Also buidling up ...

As a DBA you should now how locking works with tables and how best you can make use of indexing enhancements within SQL Server 2005 version.   Until SQL 2000 there was a limited availability of documentation on the guidelines even in the Books online and most of the times we have to depend upon the web resources or ...

Check this FAQ post for further resolution.

A list of few MSDN webcasts that are lined up in this month to enhance your knowledge in ADO.NET : ___________________________________________________________________________________________________________________ MSDN Webcast: ADO.NET Step by Step (Part 1 of 4): Getting Started (Level 200) - Wednesday, May 9, 2007. 9:00 A.M.–10:00 ...

Every PC user might have come across the error ''Access is denied'' include few others to join,  “There has been a sharing violation,” “The file is in use by another program or user,” and “Make sure the disk is not full or write-protected and that the file is not currently in use.” When this error is wrapped up under a SQL Server error or ...