Top 10 SQL Administrators Scripts You Should Know (link)
Top 10 SQL Scripts You Should Know Views – 1514
Read MoreCategory: Administration
SQL Administration Part 1
Here are some SQL Administrative queries:
|
1 |
SELECT SERVERPROPERTY('IsClustered') |
sp_configure Use Type the following to see the options the system sproc “sp_configure” has available to…
Read More
SQL Server 2012 DMV’s (Dynamic Management Views)
Notes about DMV’s in General DMV data is discarded when the SQL Server service is restarted as it is stored in memory and…
Read More