Red Gate has released SQL Scripts Manager, a free tool containing over 25 scripts written by SQL Server experts, to help you automate common troubleshooting, diagnostic, and maintenance tasks.
2010-12-23
5,954 reads
Bill Nicolich uses T-SQL to look at the community participation of people at SQLServerCentral.
2010-12-23
1,597 reads
I have mentioned before about doing development for StreamInsight in Linqpad. I have it installed on two separate PCs and I have enabled autocompletion on only one of them. Whilst both versions are an excellent tool, the one with autocompletion enabled is so much easier to use. After enabling autocompletion you can see I now get parameter listing
2010-12-23
2,439 reads
As I try to drag my team (sometimes with resistance, sometimes with pleasure) into the world of relational principles, I...
2010-12-23
1,083 reads
Running Profiler traces against multiple servers becomes a painful process when it’s time to collate and filter all that data. It would be time-consuming, frustrating and messy if Laerte hadn’t written this handy PowerShell script (complete with examples) to help you out.
2010-12-22
3,650 reads
I was reading a few forum posts yesterday where a few people were complaining that the transaction log had grown...
2010-12-22
1,997 reads
This article demonstrates how to monitor table size growth in SQL Server.
2010-12-21
4,522 reads
Onion Ring Buffer?
A client asked a co-worker to take a look at a query for reviewing RING_BUFFER_OOM messages in sys.dm_os_ring_buffers. ...
2010-12-21
828 reads
Provides undocumented adjustments to package XML to enable Annotation Word Wrapping and other features.
2010-12-20
10,073 reads
She can dig it!
D Sharon PruittWhen I started using XQuery to dig into the plan cache, it was just searching...
2010-12-20
2,013 reads
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
I’ve been doing storage load tests for SQL Server for a long time, both...
Comments posted to this topic are about the item How Long is a Long...
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Comments posted to this topic are about the item Half of All Engineers
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