In this video I talk about Trace Flag 1117 and how it was designed to help keep data file growth with multiple data files in […]
Tag: TempDB
Cannot Failover Nodes Using TempDB on Local Storage
I ran into an interesting issue while installing SQL 2012 SP1 in a failover cluster configuration and utilizing the local TempDB feature. Â If you are […]
Local TempDB on SQL 2012
This post has been sitting in the draft folder for way too long, March of last year to be precise. Â So although this is no […]
How to move the TempDB Database
Note that TempDB is recreated every time SQL starts. Why is this important? It means we don’t have to move the physical file on the file […]
You must be logged in to post a comment.