|
|
-
|
|
Disk IO performance, disk block size tuning and SQL Servers is a critical topic.
Disk IO happens at the page level. Aligning the database usage pattern with the
IO is key to good throughput.
A page is 8KB in size. Consider a page as the atomic (or fundamental) unit. Multiply
......
|
|
-
|
|
Maintaining statistics is important for SQL Server performance. The SQL Server query optimizer uses statistics to calculate \ estimate the number of rows (also known as cardinality) for a sql query . Cardinality influences the SQL Server query plan. A practical example, is the choice between an eff......
|
|
-
|
|
SQL Server uses the auto update statistics option, for automated statistics redistribution.
There are other options – such as SQL Server sp_updatstats and UPDATE STATISTICS
for more granular control
I use these options for maintenance and troubleshooting. Reasons could b......
|
|
-
|
|
Is a SQL Server transaction holding a lock on resources when the client aborts the operation?
I receive a regular question “What does the SQL Server sleeping state mean, and are resources locked?”
Let’s investigate.
Activity Monitor lists information about SQL Server processes. ......
|
|
-
|
|
SQL Server Books online defines the TRACEWRITE sql wait stat type as “Occurs when
the SQL Trace rowset trace provider waits for either a free buffer or a buffer with
events to process”
The trace rowset provider drops events from the internal buffer, if it needs the......
|
|
-
|
|
When to create a SQL Server non-clustered index? How do non-clustered indexes sit
with SQL Serrver clustered indexes?
It’s not the purpose of this post to describe a SQL Server non-clustered index,
which you will find in BOL
Firstly, the main differences with betw......
|
|
-
|
|
The SQL Server 2008 Books Online (October 2009) is one of my primary sources of
technical information about SQL Server 2008.
Best practises for SQL Server 2008
Tutorials
Conceptual outlines of SQL Server 2008 architecture
API details
Every SQL Server DBA......
|
|
-
|
|
The purpose of the article is to list my top 10 DBA tips to concentrate on in developing the competitive edge. There are of course many more DBA and related technolgies skills.
1) Read everything, across all platforms. Download SQL Server 2008 Books Online and read it all
2) Develop some extreme......
|
|
-
|
|
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......
|
|
-
|
|
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 ......
|
|