Question : My department works on converting a client’s database when a client switches from another company to us. We […]
Tag: sql-server-2005
What known bugs still exist in SQL Server 2005 after SP4 CU4?
Question : I’m assuming CU4 will be the last update for SQL 2005. We intend to stay on 2005 for […]
Backups script completes, but doesn’t back up all dbs
Question : I’m running sql server 2005 and I’ve made a simple backup script that backs up all the databases […]
Check of SQL Server upgrade success
Question : I have performed SQL Server upgrade from 2005 to SQL Server 2008. Is there any tools/possibilities to check, […]
Is it OK to use WITH INIT for my Transaction Log Backup to avoid having it grow too large?
Question : I’m still struggling to understand SQL’s backup jobs. We currently have a SQL Server 2005 instance using the […]
UPDATE in combination with nested SELECT queries and LEFT OUTER JOIN
Question : I have a problem with an UPDATE statement that contains a nested SELECT statement in combination with LEFT […]
Will transactional replication break if there is a heavy update/delete query run on the publisher DB
Question : For these specifications: Publisher: (prod OLTP DB server) SQL Server 2005, database size : 220 GB also acts […]
How do query notifications detect changes in the query result?
Question : I am working with a legacy database that has implemented query notifications against a table called ColorList. While […]
Is there a way to execute SQL statement based on SQL Server version?
Question : I would like to create computed index on a table if SQL Server is 2008 or newer and […]
App domain is marked for unload due to memory pressure
Question : In my sql server log (2005 SP4) I have this message every couple of seconds : “AppDomain XXX […]