|
|
-
|
|
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......
|
|
-
|
|
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 received a question from a client yesterday : "We've implemented a query with LIKE in the WHERE clause. But if I want to search for a suffix (LIKE '%suffix') an Index Scan is used and takes very long. Is there any way that SQL Server does an Index Seek in case of LIKE '%suffix'? How can I optimize......
|
|
-
|
|
Connecting to SQL Server from Excel is an easy process.
Users want to distribute an Excel document, for example, within
a network. Particuarly as there are plenty of libraries the user can access from Excel
as a presentation layer.
To implement this solution you will need:
Microsoft Excel
Vi......
|
|
-
|
|
A SQL Server Import Data from DB2 AS400 iSeries is straightforward, once you’ve overcome a few problems.
A common error message on a SSIS import is:
Text was truncated or one or more characters had no match in the target code paged
Associated with the following types of detailed error mess......
|
|
-
|
|
There was an unexpected server shutdown, on a sql server box. Upon restart one of
the databases went into an IN RECOVERY state,
and once the database had reached 99% complete the following message appeared in
the SQL Server log files.
SQL Server detected a DTC/KTM in-doub......
|
|
-
|
|
The database collation level is set at CREATE DATABASE. If no collation level is set, the server collation is used.
Once the database is created, a requirement may arise to change the database collation. Use ALTER DATABASE to adjust the database collation level.
To change a collation level of an e......
|
|
-
|
|
Time management, Parkinsons Law and the Pareto Principle make up this post.
I’ve just finished reading “The 4-hour work week” by Timothy Ferriss. It arrived
as a birthday present from my children. Were they trying to tell me something??
I work as a DBA full......
|
|
-
|
|
There are certain best practises for Capacity Planning to follow when considering
SQL Server Production environment.
1)Check that the hardware is modular and will facilitate hardware upgrades,
if the databases outgrow the the current hardware set up
2)Carry out a reali......
|
|
-
|
|
This is my OLTP performance checklist baseline configuration checklist, using DB2 9.1 # 9.5 for OLTP DB2 systems.
For DB2 servers supporting OLTP, I execute a script that gathers this information. Based on application requirements, these configurations can deviate.
The SYSTEM based are dependant o......
|
|