|
|
-
|
|
The dynamic management view (DMV) sys.dm_exec_requests returns information about each request that is executing within SQL Server.
Instead of using Activity Monitor to view the status of a Rollback, use this T-SQL code.
Activity monitor is based on window panes and is cumbersome to export any inf......
|
|
-
|
|
The current DBA trend is increased database management requirements and less DBAs to manage.
Many factors are responsible, such as:
1)Global trends and predictions for increased data requirements
2)Automation
3)Economic pressure to decrease size of IT departments
You can see why for many DBAs ......
|
|
-
|
|
Quotename() is a SQL Server String function.
It accepts an input string of of up to 128 characters. Which is a limitation, although you could easily create a workaround with a UDF
Returns a Unicode string of a valid delimited identifier.
Why would you use Quotename()?
1) Reviewing for SQL ......
|
|
-
|
|
Usually when the DB2 instance ends unexpectedly, trap files are created. There is usually one trap file capturing the root cause. A number of other files are created, supporting data about DB2 processes. The dbdiag.log file indicates which files to analyze.
By default, the files are created in &l......
|
|
-
|
|
Torn Pages \ Corrupt pages – all in a days work for a DBA. But can anyone tell me how to use DBCC CHECKDB and the steps to take if a corrupt page is discovered?
This is a typical question I’ll ask at an interview for a DBA. In most cases the answers are vague.
My approach on DBCC CHE......
|
|
-
|
|
Diaglevel refers to the Diagnostic error capture level configuration parameter.
There are 5 levels:
0 - No diagnostic data captured
1 - Severe errors only
2 - All errors
3 - All errors and warnings
4 - All errors, warnings and informational messages
The default is at 3.
Change the......
|
|
-
|
|
To set a DB2 database cfg value to an empty value use NULL.
It’s case sensitive. Using “null” will not work.
An example:
update db cfg for MYDB using HADR_LOCAL_HOST NULL
Republished from http://www.sqlserver-dba.com.......
|
|
-
|
|
DBAs find it easier to manage large Database Server environments when checklists are used. This Stored procedure checklist will stimulate some ideas you could use
For acceptance into the SQL Server environment, I’ve developed some scripts that scan the T-SQL code for some items in this check......
|
|
-
|
|
Storage Monitoring requires an end to end view. Consider the different types of drives and servers connecting to the sub storage system
Monitor – Hard Drives
Controllers (CPU, Caching )
Controller connectivity
Network switch throughput
HBA connectivity
Network Fabric
SAN storage monitori......
|
|
-
|
|
Use this select statement to create a list of ALTER SCHEMA statements for all stored procedures in a SQL Server 2005 database. “dbo” can be changed to whatever schema name required
USE myDb
GO
SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + p.Name
FROM sys.Procedures p INNER JOIN
sys.Sc......
|
|