Question : I want to create cartesian product sql query.But,I’m getting the error.Where I wrong? alter table #Personel ( Ad […]
Tag: sql-server-2005
UPDATE statement with and without SELECT keyword
Question : I have been doing some testing on removing the SELECT keyword from this update: Update #tmpDriverTime Set WorkDay2 […]
Bi-directional synchronization between local SQL Server 2005 and a SQL Azure using SQL Data Sync
Question : I need to synchronize an Sql Server 2005 database in an SQL Azure database. In other posts I’ve […]
How can I query data from a linked server, and pass it parameters to filter by?
Question : I have a really big query that needs to be run on multiple databases, and the results appended […]
SQL server not using the memory allocated
Question : We have noticed that for one of our SQL server with below configuration ,memory is not getting availed […]
SQL Server 2005 Huge DB issue
Question : My DB files are growing very fast ( designer is not me and just a weekly report makes […]
SQL 2005: Can we determine how much the rebuild index maintenance job can grow database log files?
Question : On SQL server 2005, if all the databases are in Full mode (with hourly transaction log backups), is […]
Process attempted to unlock a resource it does not own
Question : SQL Server 2005 SP4 32-Bit I have a DBCC CHECKDB job running nightly. Last night, soon after the […]
Full Plan Cache Behavior
Question : In SQL Server 2005, what happens when the plan cache fills up? I have done some research, and […]
SQL Server performance sudden degradation
Question : I have a SQL Server 2005 that has become unpredictable of late, and I’m scratching my head as […]