|
|
-
|
|
Use the script below to disable an index on a SQL Server table
ALTER INDEX MY_INDEX_NAME on MY_TABLE_NAME DISABLE;
Executing the code will prevent access to the index.
If it’s a CLUSTERED INDEX, the data remains intact on the table, but no DML can access the data. Drop the index or rebuild......
|
|
-
|
|
Fragmentation of an index can severely affect performance. When logical ordering of the key within a page does not match the physical ordering within the data file, fragmentation exists.
I execute index maintenance scripts for databases on a regular basis. If I’m executing a custom job, such as ......
|
|
-
|
|
If some long running error situation , the Error Log can become very big. In those situations , it can be time-consuming to search for specific Messages.
It is a good idea to recycle the SQL Server Error Logs . To create a new Error Log file without restarting SQL Server , use the sp_cycle_e......
|
|
-
|
|
Executing a t-sql statement with a convert function
convert(datetime, my_date_column) ,
threw an arithmetical overflow error with the message :
Message
Arithmetic overflow error converting expression to data type datetime. [SQLSTATE 22003] (Error 8115) The statement has......
|
|
-
|
|
Instead of just right clicking on SSMS , these are some alternatives to locating SQL Server Collation information I use.
--To find all collations available
SELECT * FROM fn_helpcollations()
--To find the SQL Server Collation level
select SERVERPROPERTY('collation')
--To find the d......
|
|
-
|
|
Common reasons for query time-outs are :
1) The application starts using a query not optimal for the index
2) Hardware changes\ Configuration changes
3) Increased load
If you suspect the query time-out is due to memory issue , continue reading.
Debugging a query-timeout is tricky. I......
|
|
-
|
|
As part of a SQL server monitoring review and agent upgrade, I was asked by the Tivoli Engineer to create a list of situations, that monitoring would be useful. The architecture used is Tivoli Monitoring /
Some considerations are:
1) By commiting to having to many situations monitored &ndash......
|
|
-
|
|
Data Center Migration, Database Servers and data migration planning is critical to a successful migration. Enterprise architects tend to categorise database servers part of the shared services layer.
I’ve been involved in a few very large Data Center migrations as the Senior DBA for DB2 and ......
|
|
-
|
|
Database size in DB2 - Find 3 methods I use to find the database size in DB2
METHOD 1 - GET_DBSIZE_INFO
============================
db2 connect to
db2 "CALL GET_DBSIZE_INFO (?, ?, ?, -1)"
METHOD 2a (in MB) snapshot_tbs_cfg
===============================
db2 connect to
db2 "select (sum(......
|
|
-
|
|
For Tivoli Application Dependancy Discovery Manager (TADDM) to successfully discover DB2 instances, standardising OS and DB2 security access is the key, particularly for a large DB2 server inventory.
A non – standardised approach can lead to may hours of troubleshooting and false negatives.
Buil......
|
|