|
|
-
|
|
When completing an installation I saw the following error – which stopped the installation.
The error occurred during the creation of Indexed View.
[2011-10-24 18:21:34.193 02944 error 'App'] A database error occurred: "ODBC error: (42000) - [Microsoft][SQL Server Native Client 10.0][SQL Server]C......
|
|
-
|
|
“In 2013 PC install base will be 1.78 billion”
“Smartphone install base to be 1.32 billion in 2013”
“By 2013, 505 million enhanced phones with advanced browsers in use”
“Mobile phones will drive more web accesses than PCs from 2013”
“By 2013, mobile phones will overtake PCs as the most commonweb......
|
|
-
|
|
1) What types of JOINS exist?
Inner Joins
Outer Joins (LEFT JOIN, LEFT OUTER JOIN, RIGHT JOIN, RIGHT OUTER JOIN, FULL JOIN , FULL OUTER JOIN)
Cross Joins (aka Cartesian Join)
2) Where are JOINS used?
Joins are implemented in either the FROM or WHERE clause
3) Why use JOINS?
JOINS are use......
|
|
-
|
|
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......
|
|
-
|
|
SQL Server Books online defines the OLEDB wait stat type as “Occurs when SQL Server calls the SQL Server Native Client OLE DB Provider. This wait type is not used for synchronization. Instead, it indicates the duration of calls to the OLE DB provider”
Examples of where OLEDB wait type may occur is ......
|
|
-
|
|
This script runs across all DB2 servers every morning and creates a report. It’s a quick way of getting DB2 health status, in my inbox. I open the report in my Blackberry , while travelling into work.
It doesn’t replace Monitoring, which deals with thresholds being met .
The script runs as par......
|
|
-
|
|
Connecting from Windows to Linux is possible with plink.exe
Plink is part of the PuTTY toolkit. Plink is the command line interface to the PuTTY backend.
One of the interesting methods to apply is connecting to DB2 on Linux. In the example below the plink command is : a connection made to Linu......
|
|
-
|
|
Using Iometer with Linux requires a few extra steps than running it on Windows.
Iometer is a great tool , but aim to test on real-data. Consider testing on tools which simulate database server IO patterns. Disk IO performance and SQLIO illustrates a more database server specific test plan.
Some......
|
|
-
|
|
The usual Proof of Concept (POC) is:
a) a new data centre build
b) a new SAN, SVC, or any other aspect of the substorage system
c) new hardware
d) new virtualized environment
As the DBA you’ll be asked to validate these new systems. Why?
You’re responsible for the operational an......
|
|
-
|
|
I’m just about to interview 2 candidates for a Senior DBA vacancy. As part of the interview process.
Technical Test
Interview (Technical, Experience & Personality)
The purpose of the Technical Tests is not to determine their memory of commands. Although, being able to recall and use......
|
|