the unindexed table is not worth querying

DFW, Texas
Joined March 2011
I'm looking for a #SQL Developer/Administrator who is interested in a FT position in Irving/Las Colinas, TX. Come play with some #VLDB tenaska.com/careers/
OK, buckle up. I wanna talk to you about Triscuit.
2,478
34,976
14,473
141,856
It is so exciting to see your employees grow to the level of expert. I'm very proud of my team tonight. We had a successful SQL Server Cluster migration that I didn't have to lay a finger on!
1
Truly enjoyed seeing this show again. It was awesome seeing it in person last month and seeing it again tonight live brought me back there. #TheSmashingPumpkinsLive
2
Happy 25th Birthday, World Wide Web. Thanks @CERN !
Inbox Zero is Zen... And the only way I don't twitch! xitter.cf/DynamicWebPaige/status…
...but I have inbox rules. I HAVE INBOX RULES #InboxZeroIsAMyth ☹️
Does anyone know how to find the latest LSN restored to an active #sql mirror, not only transferred, but restored to datafiles? TIA #sqlhelp
1
1
That moment when you realize you've been altering the clustered index on the 600 million row table, rather than the 8 million row test table
When a business user makes a single decision to run a new calculation and your database grows by 100GB more than usual, #VLDB #SQL problems.
1
Brad Hoff retweeted
Second stage and SES-9 spacecraft in nominal coast phase
38
273
964
Trying to stop mirror from DR side, failing with db mirror is busy, tried stopping/starting endpoints, other suggestions? TIA #sqlhelp
The best part is getting rid of those tiny two VLFs at the front: bradhoff.com/forTwitter/FewV… xitter.cf/rabryst/status/6951154…
1
New Blog Entry: Resolving Disconnected #SQL Server Mirrors sqlphilosopher.com/wp/2016/0…
You’re unable to view this Post because this account owner limits who can view their Posts. Learn more
New Blog Entry: Sneaker-Net Saves a 20 TB #SQL Mirror sqlphilosopher.com/wp/2016/0…
What a week! connection to DR site down, been sneaker-netting T-logs just to keep head above water, might have to blog about this one #sql
1
In Oracle I can sneaker-net ArchiveLogs to Dataguard 2nd to apply Redo if disconnected. Is similar possible with T-log bkps in SQL? #sqlhelp
2