tag:blogger.com,1999:blog-7334907730481072936.post3641071688231427753..comments2024-03-08T00:16:50.328-08:00Comments on SQL Server Expert: What is TEMPDB in SQLServer?Satishbabu Gunukulahttp://www.blogger.com/profile/02630966486825083489noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-7334907730481072936.post-42733851470244214982017-08-19T11:14:53.753-07:002017-08-19T11:14:53.753-07:00Hi,
How many filegroups can temdb have ?Hi,<br />How many filegroups can temdb have ?priyahttps://www.blogger.com/profile/07572485284959881009noreply@blogger.comtag:blogger.com,1999:blog-7334907730481072936.post-90818686613043509072016-08-21T23:29:42.460-07:002016-08-21T23:29:42.460-07:00Very helpful.Very helpful.Anonymoushttps://www.blogger.com/profile/01786593266385107492noreply@blogger.comtag:blogger.com,1999:blog-7334907730481072936.post-61090649872897592602014-01-22T10:09:14.869-08:002014-01-22T10:09:14.869-08:00Great article. When you say that query, cursors an...Great article. When you say that query, cursors and triggers use tempdb, does that include performing a delete statement as well ? In other words, if I delete 1 million records from a table, does that affect tempdb size ?<br />Thanks<br />Administrador do Bloghttps://www.blogger.com/profile/00041629171596144479noreply@blogger.comtag:blogger.com,1999:blog-7334907730481072936.post-20986790729309790962012-12-20T12:04:44.644-08:002012-12-20T12:04:44.644-08:00Each time the SQL Server service starts, the tempd...Each time the SQL Server service starts, the tempdb is newly created by copying from the model database and inheriting some database configurations from it. Note that shrinking the tempdb causes fragmentation and other issues.<br /><br />Please see my other post on "Shrink TempDB". It should clear all your doubts.<br /><br />http://www.sqlserver-expert.com/2012/03/how-to-shrink-tempdb-in-sqlserver.html<br />Satishbabu Gunukulahttps://www.blogger.com/profile/02630966486825083489noreply@blogger.comtag:blogger.com,1999:blog-7334907730481072936.post-30266267943786331682012-12-20T00:06:56.086-08:002012-12-20T00:06:56.086-08:00very informative!
i got this like:
user can manip...very informative!<br />i got this like:<br /> user can manipulate tempdb but it will resume its original state after sql server restarts or session ends... is that so?<br />thanksWardahhttps://www.blogger.com/profile/11918049088042958980noreply@blogger.com