The Fragmented Index Bow Tie Review


Little known fact, telling fabulous stories about bow ties is not my day job. Actually, my full time job is a SQL DBA (Database Administrator)  It's hard work but someone has to reindex those fragmented tables. If you are ever in the need for a quick script to find fragmented indexes across all databases take a look at this handy script, from our good friend over at Pinal Dave exhibits a whole plethora of information about SQL Server, and heck we probably should have just named this bodacious bow tie after Mr. Dave, but I digress.

SELECT ps.database_id, ps.OBJECT_ID,

ps.index_id,,ps.avg_fragmentation_in_percentFROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) ASpsINNER JOIN sys.indexes AS b ON ps.OBJECT_ID = b.OBJECT_IDAND ps.index_id = b.index_idWHERE ps.database_id = DB_ID()ORDER BY ps.OBJECT_ID

Anyways, lets focus on this busy bow tie. Notice it's deep woven checkered roots. Spinach greens, mustard yellows, and mother of pearl whites. This bow tie lets you show off your geeky-ness, if you know what it's all about, and if you don't, that's okay too. Because, this bold beautiful bow tie will pop in any event. If you want to know a little more about SQL check out my other blog post - SQLROOK

[caption id="attachment_47" align="aligncenter" width="490"]Fragmented Index Bow Tie Fragmented Index Bow Tie[/caption]

Leave a comment

All blog comments are checked prior to publishing
You have successfully subscribed!
Ella Bing Reviews

What our customers are saying.

949 reviews
Great experience!

Very cute store with unique items, a darling dog and excellent customer service.

Amazing store

Stumbled upon this amazing store. Can’t recommend it enough.

Polarized Wood Sunglasses No. 2230

Loved your store. Love my new handmade glasses and my cigar box. The associate that helped me at the Hyde Park location was fantastic.

Snappy Shop!!

Thank you Brent for your fun shop! So many charming items to choose from. Love my new wooden tortoise sunglasses:)

The Music!! The creativity!

The vibe is just great! The music just makes you stay there while shopping Lol. If looking for a super creative gift, that’s the place to go!