Notes about Server SSDs
Note: This isn’t a recommendation or endorsement, just notes from some research I’ve done. Please contact your vendor before making...
2010-06-03
552 reads
Blog Posts
One more Fix Database Role in SQL Server
Fixed Database Rols are: db_ddladmin, db_owner, db_accessadmin, db_securityadmin, db_backupoperator, db_datawriter, db_datareader, db_denydatawriter, db_denydatareader + one more that is dbm_monitor.
This is...
2010-06-03
1,697 reads
Performance Tuning Series
To kick off this blog, I am going to start with a topic that is hot on the mind of...
2010-06-03
754 reads
Sins of a Recursive CTE?
On June 1, 2010, Steve Gray had an article, Sins of SQL: The Time Table, published on sqlservercentral.com. I’m not...
2010-06-03
2,591 reads
Slides from SQL Server Auditing Class
Here are the slides from the SQL Server Auditing Class held on June 2, 2010.
Hour 1 - Attacking SQL Server
Hour 2...
2010-06-03
1,017 reads
SQL 2008 r2 version comparison
Comparison between Enterprise and Standard Versions of SQL 2008 R2
I’ve found myself recently trying to justify the need for Enterprise...
2010-06-03
10,142 reads
T-SQL Tuesday coming next week
The T-SQL Tuesday party #7 is coming next Tuesday, June 8th. Since it’s TechEd week, and I’ll be there along...
2010-06-03
390 reads
Weekly Update - Internet Issues
I haven’t written anything technical or SQL Server related for that matter on my blog for a few of weeks....
2010-06-03
636 reads
Alternating Group Colors
Formatting reports can be a fun process. I personally look at myself as a Monet or Picasso when creating my...
2010-06-02
505 reads
Calculating ROI on Performance Tuning
Recently on the SSC forums, someone asked about how to measure the money in an actual dollar figure that they...
2010-06-02
744 reads
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
Make your moments memorable with Fildena 200mg
Make your moments memorable with Fildena 200mg, a high-strength option designed to support men...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers