tempdb drive fill up, restart service?

-

hello,

when tempdb fills drive, restart service clear things out. there way? mean more "elegant"

thanks

hello,

you can try dbcc shrinkdatabase (transact-sql) on tempdb.

and future: troubleshooting insufficient disk space in tempdb and monitoring tempdb transactions , space usage

olaf helper

[ blog] [ xing] [ mvp]



SQL Server  >  SQL Server Database Engine



Comments

Post a Comment

Popular posts from this blog

Motherboard replacement

-
running windows 10 technical preview, need replace motherboard can run the  sysprep  command restoring pc ? or there easier  or more preferred way ? thanks if replace motherboard within same family of chipsets (i.e. intel > intel or amd > amd), should okay restarting pc twice. carey frisch Windows 10 Insider Preview  >  Windows 10 Insider Preview General
Read more

Remote Desktop App - Error 0x207 or 0x607

-
hi all, i manage windows 2012 r2 network, including connection broker, session hosts , remote apps virtual servers.  i've used remote desktop app on own android phone, no issues @ - connects published gateway url , can login , access network. we looking move business onto nokia handsets ms operating system (currently on blackberry), not able connect via remote desktop app on nokia lumia handset. setup, per android config , brings remote apps , remote desktop screen, know can connect.  when select remote desktop, shows following process: initiating remote connection securing remote connection certificate can't verified - choose connect it digitally signed cert (digicert sha2), pc name different physical connection broker name (inherited domain name old gov project - can't publish publicly) initiating establishing securing connection error have been 0x207 getting 0x607 a bit baffled, work on android (and ipad @ home using app). assume ms use d...
Read more

Top N or Bottom N filter based on a parameter

-
i have report parameter selection filtering data, either "highest" or "lowest".  if pick "highest" want top n, if "lowest" want bottom n.  how can set in filter ? j. way there many ways set report accomplish this. e.g asuming "n" fixed, you'll set report parameter has 2 hard-coded values "top" , "bottom" , based on user selects, can write report dataset query if (parameter value = "top") select top n ...... else if (parameter value = "bottom") select top n ......order <ordered column name> desc (again there other ways of doing too) else (whatever business logic needs go here, if @ all) if wanted keep n input parameter well, in addition above top/bottom filter, you'll add input filter (preferably free-text input) accept n , build dynamic sql string concatenating input parameter value in logic above. hope gets on right track. cheers! -muqadder. ...
Read more