I inherited a SQL 2005 server. Initial installation has the sytem DBs on the O/S partition. So were all the user DBs. I was able to move all the user DBs to another partition and want to do this with the system DBs but have been running into problems. I have read everywhere that talks about using SQL...

Afternoon All, I'm after a bit of help on a query i'm trying to write in T-SQL and if i can help it, by avoiding creating functions in the database as i'm using 3rd party software. I have a StartDate and an EndDate, and I need to show the StartDate, the EndDate and all the dates in between...

hi all..myself deep SQL Server DBA(Trainee) first what is my problem : we have database of more then 225 GB i take three log backups daily and size of backups from last two week is large in comparison to previous backups. i want to check what tables are updated very bulkly means i want to find those...