Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2012-01-16 : 09:00:26
|
| i am executin query(select statement) the query is running with multiple joins( required for interest rate and penal interest calcultion purpose) when i executing that query it is taking more than 10 min and it is giving these error--------------Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup 'DEFAULT'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.------------------------i have created indexes of required tablescan any body help me |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-01-16 : 09:29:40
|
This is your problem:... insufficient disk space in filegroup 'DEFAULT' ...
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-16 : 10:27:24
|
| because its tempdb restarting will fix currentbut for a permanent solution move tempdb.mdf to drive with more spaceor run the large dataset queries as small batches to avoid tempdb space filling up again------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
sql query execution given error