|
|
-
|
|
SQL open transactions are a good way of troubleshooting SQL Server performance issues. Quite often a SQL Server performance starts and you need to know what SQL open transactions exist. And what T-SQL is running.
Which SQL open transactions are causing a performance issue?
Method 1 - DBCC OPENTRAN......
|
|
-
|
|
“Please post real DDL. Learn to use ISO-11179 rules for the data element names, avoid needless dialect and use ISO-8601 temporal formats, codes and so forth.”.
This is a familiar quote from Joe Celko. On this occasion found on:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=1611......
|
|
-
|
|
DBA Interview Questions and Answers for a DB2 on Linux, Unix and Windows DBA focusing on DB2 Security Management
Read the DB2 Security Notes for checklists on DB2 Authentication Types, Authorities, DB2 Privileges, Object
Privileges, GRANT & REVOKE usages
What is the purpose of Authoriti......
|
|
-
|
|
SQL Server Error 26 relates only to SQL Server Named instances. Not default instances
The main reason SQL Server Error 26 error message appears is that the client can’t receive SQL Server Resolution Protocol(SSRP) response UDP packet from the SQL Browser Service
1)Check the server name is......
|
|
-
|
|
SQL Server DMV and functionsare one of my favourite SQL Server features when tuning SQL Server Index performance.
I use the following 5 SQL Server DMVs for general overview
1. sys.dm_db_index_usage_stats
Maintains counts for the range of index activity and the last performed time. Also display......
|
|
-
|
|
I typed the Linux Command GET DBM CFG
into my Putty console – rather than db2 GET DBM CFG and web page code was
returned. That’s interesting!
The GET program is used to send requests to www servers. There are various switches,
such as:
-b This URI will ......
|
|
-
|
|
Using SQL Server CTE and PARTITION BY – the following problem was solved – instead of using GROUP BY.
The SQL Server CTE is a temporary resultset. It’s not stored as an object – and the scope is for the query.
In conjunction with SQL Server PARTITION BY – which fi......
|
|
-
|
|
Welcome to a series of posts on DBA Interview Questions and Answers for a DB2 on Linux, Unix and Windows.
Assist me by commenting , supplying feedback and making suggestions on DBA Interview Question and Answers for DB2.
DB2 DBA Interview Questions and Answers – Server Operations
Future Po......
|
|
-
|
|
SQL BACKUP failed to complete BACKUP LOG and sql error 3041.
The Backup Operators reported a SQL Server BACKUP failed error. They attached the TSM log entry.
20-05-2011 20:31:34 ACO5422E Received the following from the MS SQL server:
20-05-2011 20:31:34 An exception occurred while executing ......
|
|
-
|
|
Bulk Insert CSV into a SQL Server table is common task for developers and DBAs.
Before starting find out:
1)the FIELDTERMINATOR –
2)row terminator
CSV is defined as Comma Separated Values . Despite the “comma” word, it is possible to use other characters – as the FIELDTER......
|
|