SQL Server – Logical Disk Read Bytes/sec and disk io
In the SAN environment , the Logical Disk Performance objects counters monitor the logical partitions.
I use the Logical Disk Read Bytes/sec ...
2012-01-12
1,851 reads
- Interests: Performance Tuning Database Servers, Running and Coffee
SQL Server – Backup to NUL trick - read throughput
A neat test for read speed backup throughput is to use the Backup to NUL .
NUL is a special “file”. It's...
2012-01-11
953 reads
SQL Server – Maintaining different environments
A busy Database Server and application development environment can have – Sandbox, Dev, Test, QA, Staging, Production .
Maintaining multiple environments requires...
2012-01-10
2,650 reads
SQL Server –WRITELOG and how to reduce it
SQL Server Books online defines the wait type WRITELOG as “Occurs while waiting for a log flush to complete. Common...
2012-01-09
1,269 reads
Arithmetic overflow error and isdate sql
Executing a t-sql statement with a convert function
convert(datetime, my_date_column) ,
threw an arithmetical overflow error with the message :
Message
Arithmetic overflow...
2012-01-06
1,252 reads
SQL Server Disable Indexes and Rebuild Indexes dynamically
To generate the ALTER INDEX..DISABLE and the ALTER INDEX..REBUILD statements for all nonclustered indexes for a single table use the...
2012-01-05
1,167 reads
SQL SERVER REBUILD INDEX
Use the script below to rebuild an index on a table
ALTER INDEX MY_INDEX_NAME on MY_TABLE_NAME REBUILD ;
Check SQL Server...
2012-01-04
1,043 reads
SQL SERVER DISABLE INDEX
Use the script below to disable an index on a SQL Server table
ALTER INDEX MY_INDEX_NAME on MY_TABLE_NAME DISABLE;
Executing the...
2012-01-03
1,437 reads
SQL Index Fragmentation and sys.dm_db_index_physical_stats
Fragmentation of an index can severely affect performance. When logical ordering of the key within a page does not match...
2012-01-02
1,000 reads
SQL Server DBA – Grow as a DBA
It’s the first day of 2012. Setting New Year Resolutions is often a futile activity – and resolutions I’ve set in...
2012-01-01
396 reads
Blogs
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Forums
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
UNISTR Basics
Comments posted to this topic are about the item UNISTR Basics
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers