Can Deadlocks be Resolved by Adding an Index?
Can Deadlocks be Resolved by Adding an Index? Yes. Really, I’m not kidding. Here, I’ll show you how.
First, let me...
2010-09-27
1,434 reads
Parameter Name Size And Performance
I saw an odd statement the other day, “The size of the name of the parameter does not affect performance.”...
2010-09-27
1,036 reads
Orlando – Reminder to Register for SQLSaturday #49
We’re less than 30 days out from SQLSaturday #49 and we’re working hard on the logistics. Speaker gifts ordered, lanyards...
2010-09-27
637 reads
Index Black Ops Part 4 – Index Overhead and Maintenance
In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in...
2010-09-27
1,139 reads
SQLRally After Hours
One of the things we’re trying to do at SQLRally (May 2011 in Orlando!) is support and grow the social...
2010-09-27
573 reads
People are talking about you
I was listening to a friend give a presentation on getting a job recently. In the presentation, Chris Shaw, the...
2010-09-27
970 reads
Food Drive
Don’t forget the food drive tomorrow for SQL Saturday #52 in Colorado. Please bring food, or even clothing/blankets, that can...
2010-09-24
633 reads
Free SQL Server Training for the Week of September 27, 2010
Tuesday
PASS Application Development Virtual Chapter - Next-Level SQLCLR: Parallel Processing and Bulk Load - Adam Machanic
Pragmatic Works - Performance tuning the cube - Adam...
2010-09-24
778 reads
A day of rest
Not quite a day of rest, likely some chores in advance of another busy weekend at the ranch.
I’m taking today...
2010-09-24
721 reads
A Little Help with Azure Please
Not long ago Microsoft announced a new product called Azure AKA “SQL Server in the Cloud”. I have to say...
2010-09-23
334 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
DanDan Jl Panjang Cidodol | WA:083121526888
Jl. Cidodol Raya No.46, RT.6/RW.6, Grogol Sel., Kec. Kebayoran Lama, Kota Jakarta Selatan, Daerah...
DanDan Kavling Polri | WA:083121526888
Kavling Polri, Jl No.1601 Blok F 8, RT.8/RW.02, Jelambar, Grogol petamburan, West Jakarta City,...
Toko Kosmetik Sumber Ayu | WA:083121526888
Pasar Tomang Barat (Pasar Kopro) Lt Dasar Blok B-48, RT.14/RW.5 (depan parkiran motor), Tanjung...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers