Apr 29, 2010 | Scripts, SQL Server 2005, SQL Server 2008, SQL Server Internals, SQLServerPedia Syndication, System Databases |
How do you tell when your SQL instance was lasted restarted? I was reading a post by Joe Webb (Blog|Twitter) about a query he uses to to gather information about his clients SQL Server instance including how he find out when an instance of SQL Server was last...
Mar 28, 2010 | SQL Server 2005, SQL Server 2008, SQLServerPedia Syndication, System Databases |
I took control of a new server recently and noticed that Tempdb was not configured to best practice. It was not on its own drive and it consisted of one data file and one log file…The server had a couple of cores, I’m not sure how relevant this is anymore but SQL...