Browse by Tags

• benchmark
• best practices
• build
• compatibility
• comptability
• database
• databases
• hotfix
• performance
• SQL Server
• tables
• technet
• trigger
• tsql
• upgrade

• Quick Update : New Cumulative Update has been released

  Microsoft has released a new cumulative update (build 3200) for SQL Server 2005. http://support.microsoft.com/default.aspx/kb/941450 Adam has pointed out that the wording in the article is incorrect; it calls these post-SP3 updates, which is obviously Read More... Posted Wednesday, October 17, 2007 12:59 PM from Aaron Bertrand | (Comments Off) Filed under: version, hotfix, build

• Setting database compatibility to SQL 2000 on a SQL Server 2005 instance?

  No doubt that as compare to previous version the current SQL Server 2005 provides more new language constructs and primitives for the T-SQL language than can be utilized. Still there are many out there not entirely ready to upgrade from SQL Server 2000 Read More... Posted Thursday, August 30, 2007 8:02 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, databases, version, upgrade, best practices, benchmark, compatibility, technet

• TSQL to find all triggers in a database including their count

  For SQL Server 2000 version: SELECT S2.[name] TableName, S1.[name] TriggerName, CASE WHEN S2.deltrig = s1.id THEN 'Delete' WHEN S2.instrig = s1.id THEN 'Insert' WHEN S2.updtrig = s1.id THEN 'Update' END 'TriggerType' , 'S1',s1.*,'S2',s2.* FROM sysobjects Read More... Posted Thursday, August 23, 2007 6:28 PM from SSQA.net | (Comments Off) Filed under: SQL Server, tables, tsql, version, trigger

• Database Compatibility version numbers juggling from 40 to 100

  A stream of database compatibility numbers has come up to my mind while we are performing few configuration changes to the database to support a legacy application that can work upto SQL Server 2000. So what number we used during the days of SQL Server Read More... Posted Wednesday, August 15, 2007 8:29 PM from SSQA.net | (Comments Off) Filed under: SQL Server, database, version, comptability