|
|
-
|
|
When analysing the full Query Response time, it is of value to break the cycle down into 3 stages. This will allow greater understanding of what is occurring and how to resolve any delays.
These three phases, will equal Total Time time taken for a query to respond.
CPU (Running) = When in Running ......
|
|
-
|
|
While executing a ALTER INDEX statement the Disk is Full message occurred. A quick look at the drive dedicated for transaction logs indicated the disk was in fact full .
The following statement resolved the problem – and the reindexing job was able to continue.
This statement added a secon......
|
|
-
|
|
SQL Server, Windows Virtual memory and paging file location require some configuration changes to optimise perormance
On Windows 2008, there is an option to Automatically manage paging file size for all drives.
It’s the default configuration for Windows.
SQL Server doesn’t need ......
|
|
-
|
|
I’m a DBA in a data centre with 400+ database servers , supported by 3 DBAs. Administering
T-SQL best practises is one of the challenges.
I’d like to review and sign off all T-SQL code, prior to production release. Due
to priorities, it’s not possible to re......
|
|
-
|
|
Migrating database servers, often requires decisions on whether to virtualize. There are plenty of tests, criteria and documentation on metrics for testing on virtualized database servers.
I’m working on a large data centre migration. One of the objectives is to list out database servers ......
|
|
-
|
|
Key Points
Creating a common foundation between SQL Azure Cloud and Denali. Denali is SQL Server version 11 of the SQL Server Code.
Expanding capability for spatial data types - Geometry data type (Euclidean - flat-earth) and Georgraphy data type (ellipsoidal – round earth).
To interact ......
|
|
-
|
|
Certain Dynamic Management Views(DMV) return a sql_handle column.
Examples of DMVs returning the sql_handle column are:
sys.dm_exec_query_stats
sys.dm_exec_requests
sql_handle is a varbinary(64). A varbinary is suitable for variable length binary data. The sql_handle is a token referencing a ......
|
|
-
|
|
This powershell script assists in applying a similar change on every SQL Server
Instance. Or a subset.
For example, adding a new generic logon account, or collecting regular information.
I’ve written plenty of powershell scripts – that are customised for a partic......
|
|
-
|
|
Table variables and Temporary tables are used interchangeably – but they were designed for different purposes.
Temporary tables were designed for storage and manipulation of temporal data.
Table variables were designed to return User Defined Function (UDF) datasets.
Which type should be used ?......
|
|
-
|
|
The DB2 code set value defines the character encoding used by the database. Setting the appropriate value for translation, for example: Euro symbol and DB2 database codeset
To get the DB2 database code set value, use:
db2 get db cfg for MY_DB
--From a command line, such as Putty,
db2 get ......
|
|