Quick tip: sp_configure and sys.configurations
In order to query the configuration settings of a server you can run this sproc:
exec sp_configureOn a default install of...
2012-05-16
1,098 reads
In order to query the configuration settings of a server you can run this sproc:
exec sp_configureOn a default install of...
2012-05-16
1,098 reads
Replication is one of the more complex of the SQL native “HA/DR” technologies. There are a lot of moving parts....
2012-05-15
1,671 reads
I was working with a group of students on a design brief. The brief was to partially implement a database...
2012-05-10
1,021 reads
This is a very cool and useful tip if you find yourself locked out of the sysadmin role in sql...
2012-04-30
2,606 reads
I came across an issue today where a backup process was in a blocked state with a wait type of...
2012-04-24
596 reads
While researching the steps required to service pack SQL Server on an active active cluster I came across a lot...
2012-04-16
903 reads
A while ago I blogged about instant file initialization. A colleague of mine pointed out that there is a small...
2012-04-16
887 reads
The other day I was asked to restore a production database into a development environment and then check the database...
2012-03-21
823 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Hello all, I would like to create an INSERT statement and use a UDF...
Comments posted to this topic are about the item Initial Config of tempdb
Sample data: jan 10gb feb 15gb mar 16gb april 14gb(truncate data) may 18gb june...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers