Mirrored: 10th of November 2011, 06:15 Original: clinthuijbers.wordpress.com Views: 72 Settings: Loading the mirror...
Link: prev: SQL Server 2008R2: Edition comparison & Pricing Link: next: ProperCase Format (`bla bla' -> `Bla Bla') Link: canonical Link: shortlink Link: apple-touch-icon-precomposed Link: openid.server Link: openid.delegate Clint Huijbers's Blog Microsoft BI consultant * HOME * About Don't forget to clean up your TempDB regularly Cleaning up your TempDB is pretty simple: just restart your MS SQL Server Service. And...to make it just a little bit easier (if possible)...you might want to schedule it :) Start with creating a Batch-file (for example: `Restart SQL Services.bat`) Start Notepad and copy/paste the following text: @ECHO OFF NET STOP SQLSERVERAGENT NET STOP MSSQLSERVER NET START MSSQLSERVER NET START SQLSERVERAGENT Save the file and rename it to `Restart SQL Services.bat`. Now go to Start Menu -> Control Panel -> Scheduled Tasks -> Add Scheduled Task Click trough the wizard and select `Command Prompt`, setup the schedule and fill in the right credentials. Before you hit Finish, don't forget to select `Open advanced properties for this task when I click Finish`. Within the Advanced Properties Window @ `Run`: Select the Batch-file you've created and that's it! Like this: Like Be the first to like this post. 2010 08/03 CATEGORY SQL Server 2005 SQL Server 2008 SQL Server 2008 R2 TAGS Batch MSSQLSERVER Services SQLSERVERAGENT TempDB Write comment * Write comment * Comments RSS * Trackback ( 0 ) * Comments ( 1 ) 1. * Minaz * March 23rd, 2011 * REPLY * QUOTE In production you will not be able to shutdown the service, you need some different scenario :) TrackBack URL _____________________________________________________________ 1. No trackbacks yet. Leave a Reply Cancel reply Enter your comment here... _________________________________________ _________________________________________ _________________________________________ _________________________________________ _________________________________________ _________________________________________ _________________________________________ * Guest * Log In * Log In * Log In Gravatar Email (required) (Not published) _____________________ Name (required) _____________________ Website _____________________ WordPress.com Logo Please log in to WordPress.com to post a comment to your blog. Twitter picture You are commenting using your Twitter account. ( Log Out ) Facebook photo You are commenting using your Facebook account. ( Log Out ) Cancel Connecting to %s [ ] Notify me of follow-up comments via email. [ ] Notify me of new posts via email. [ Post Comment ] My recent posts * Microsoft's Productivity Future Vision (2011) * Query to Find Column From All Tables of Database * Show largest tables * Generate random password * Microsoft PowerView (previously known as Project "Crescent") on WinPhone7.5, IPAD, Android and Windows 7 [IMG] [IMG] [IMG] SQL Server 2008, Business Intelligence Development and Maintenance Microsoft Certified - Business Intelligence 2008 (MCTS) Archive * October 2011 (5) * September 2011 (2) * August 2011 (4) * July 2011 (9) * June 2011 (1) * April 2011 (1) * March 2011 (2) * February 2011 (6) * January 2011 (5) * December 2010 (6) * November 2010 (9) * October 2010 (7) * September 2010 (3) * August 2010 (2) * July 2010 (9) * June 2010 (6) * May 2010 (1) * April 2010 (6) Tag Cloud 2008R2 AdventureWorks Azure BI Bing Maps Business Intelligence Common Table Expression (CTE) Crescent Database Dataset Denali Download Drill down Editions ESRI Excel 2010 Express Expressions Function Gartner Index Map MDX Microsoft MSSQLSERVER Multi-value Parameter PowerPivot Project Crescent Shapefiles SQL SQL Azure SQL Server SQL Server 2008 SQL Server 2008R2 SQLSERVERAGENT SSAS SSIS SSRS SSRS 2005 Stored Procedure T-SQL Table Variable TempTable UDF Blog Stats * 18,098 hits SEARCH _____________________ [ Search from this blog. ] TAG LIST * Express * Map * Function * Download * Expressions * SQLSERVERAGENT * Editions * MDX * Multi-value * Dataset * Gartner * BI * AdventureWorks * Parameter * SQL Azure * Business Intelligence * SSIS * SSRS 2005 * Denali * Database * SQL Server 2008 * MSSQLSERVER * PowerPivot * SQL * Stored Procedure * T-SQL * 2008R2 * SQL Server 2008R2 * SQL Server * SSRS Blog at WordPress.com. | Theme: monochrome by mono-lab. Follow Follow Clint Huijbers's Blog Get every new post delivered to your Inbox. _____________________ [ Sign me up! ] Powered by WordPress.com