|
|
-
|
|
I received the following message from a Developer. The message was on a Test SQL Server.
“NC_myIndex " on table "VeryLargeTable" (specified in the FROM clause) is disabled or resides in a filegroup which is not online.
The cause of the message was that the index was disabled. I discovered th......
|
|
-
|
|
The Storage manager asks the DBA questions about SQL Server Storage suggestions. As the DBA you will need to answer or advise the recommendations. This could happen when a) a new storage array is under consideration b) Performance analysis c) Data Centre migrations.
These are questions I&rsqu......
|
|
-
|
|
Lazy writing , eager writing and checkpoint use asynchronous IO in writing pages to disk. The purpose of asynchronous IO is to release resources and for other tasks to progress.
i.e releases the thread to allow further threads.Usually this takes less than 10 ms – but under circ......
|
|
-
|
|
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......
|
|
-
|
|
An XA transaction is a global transaction usually covering multiple resources.
Use the Microsoft SQL Server JDBC Driver to support the Java Platform based distributed transactions
Steps to enable XA transactions
1) Enable MSDTC
On Windows 2003 > Start > Run > “dcomconfg” > Expand Componen......
|
|
-
|
|
Sometimes end users interchange the terms : C2 auditing and Traces. They server different purposes.
c2 auditing records all attempts (successfull and failed) on objects and statements. Typically a SQL Server DBA will use a c2 audit to monitor security compliance .
A trace will will monitor an even......
|
|
-
|
|
To copy a table from another SQL Server Instance is easy. Create a Linked Server on the destination server and reference the Linked Server in the SELECT statement.
1) Create linked server
/****** Object: LinkedServer [SERVER1\SQL_SERVER_INSTANCE_1] Script Date: 02/02/2012 09:29:33 ******/
EX......
|
|
-
|
|
What if you had to create a script stack that installs SQL Server from an image library? And customisations – such as adding the SQL Server Start up account to the Lock Pages in Memory Local Policies?
If this needs to be rolled out quickly across hundreds of servers, or just one, then there ......
|
|
-
|
|
A couple of years ago, I heard some new terms: “10x developer” and “2x developer”.
A 10x developer seemed to complete tasks almost instantly. A 2x developer took a
long time to complete a task. These terms can also be applied to other jobs such
......
|
|
-
|
|
Torn Pages \ Corrupt pages – all in a days work for a DBA. But can anyone tell me how to use DBCC CHECKDB and the steps to take if a corrupt page is discovered?
This is a typical question I’ll ask at an interview for a DBA. In most cases the answers are vague.
My approach on DBCC CHE......
|
|