Browse by Tags

All Tags » users » best practice (RSS)
SQL Server 2008 Change Data Capture - Do you really want to log all the data activities such as audit trails?
Published 1 February 8 9:50 AM | SSQA.net
In continuing from the series of Change-Data-Capture tags on this site I have been testing through this CDC feature on my test environment, which has proved fruitful results (to some extent). But the in the real world scenario do you really need to log...
Filed under: , , , , , , , , , , ,
SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!
Published 25 January 8 3:41 AM | SSQA.net
Though it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation...
Filed under: , , , , , , , , , , , , ,
SQL Server 2008 virtual training available during January
Published 2 January 8 3:7 AM | SSQA.net
Got this exciting news for the SQL Server users to get acquaintance in the next release which is 2008, Microsoft is offering several training opportunities before getting the RTM version to the public. This time the training opportunity is provided by...
Filed under: , , , , , , ,
SQL Server 2005: Deny Server-Level Dynamic Management Views to public group
Published 21 December 7 7:47 AM | SSQA.net
As you are aware DMV - Dynamic management views are very good to provide server-level information and some of them with detailed information on the execution environment of the database engine. Just to introduce about DMVs, there are two types of dynamic...
Filed under: , , , , , , , , , ,