Another Reason to Avoid Cross-Database Ownership Chaining
This past weekend we were moving database files around because we added new LUNs to an existing production cluster. We...
2009-02-13
2,154 reads
Blog Posts
Color E-Ink
I love my Kindle, but it uses an older e-ink technology that's a little slow and doesn't support color. Not...
2009-02-13
970 reads
SQL Injection - It's Not Just Me!!
I have a personal web site I set up years ago, mainly so I could post stuff for my extended...
2009-02-13
824 reads
Which is Better: Heaps or Tables with Clustered Indexes?
I have always been of the personal opinion that all SQL Server tables have a clustered index. As part of...
2009-02-13
4,291 reads
Inserting Markup into a String with SQL
There are a number of occasions when one might want to insert information at various places in a string. Where...
2009-02-12
1,876 reads
Landing on the Hudson River & Being a Hero
I think we've all seen and heard about Flight 1549 doing the emergency landing on the Hudson River. Truly a...
2009-02-12
565 reads
Things You Know Now…
Someone tagged me, and I’ve lost the email in all the pile up from vacation where I was very, very...
2009-02-12
1,032 reads
Counterpoint: Against Specialization
Brent Ozar wrote his Things you know now and in it he says this under his first point, Pick one...
2009-02-11
2,226 reads
Kindle 2
The Kindle 2 was announced recently and it’s on sale at Amazon, starting shipping Feb 24, 2009.
I’m glad I didn’t...
2009-02-11
794 reads
Networking - Part 4
You may want to read Part 1, Part 2, and Part 3 before continuing. This time around I'd like to...
2009-02-11
547 reads
Blogs
Scaling PowerShell – Lessons from a Technical Interview
By gbargsley
Recently, I was in a technical interview where the topic of running PowerShell at...
Installing Old Versions of PowerShell Modules with Their Dependencies
By alevyinroc
I don’t recall where this came up (probably in SQLSlack), but I had a...
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Forums
how to get notification that my database has corssed 8gb
i have sqlexpress on rds, is there any way i can get notifacation that...
SQL Server, Heaps and Fragmentation
Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation
Stairway to Azure SQL Hyperscale – Level 2: Page Server Architecture Explained
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Question of the Day
SQL Server, Heaps and Fragmentation
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers