quote:Originally posted by Donoval
I have a database that is about 60GB. When I run the query below I over-run the filegroup - which has about 12gb...
Not trying to beat a dead horse but..
"TEMPDB is a system database and in order to MODIFY any of the system database, SQL Server services...
Yes, I read that article but that solution again requires that you restart SQL server to complete the move. As does every article I have...
So I searched the forums, read referenced articles, etc. and didn't see this as a possible solution so I thought I'd ask the Gurus.
I have 5 data...
"I also noticed that all queries took long time to run at that specific timespan."
Do you have any backups running at this specific timespan?
sp_helpdb will list all of the databases.
Thanks Luis for the reply.
I wasn't aware that the servers had been changed out.
I posted a message on General DBA Questions forum on Monday Night.
I had a major issue with SP4 where it degraded the performance on my servers to...
Separate names with a comma.