Coffee and SQL

Columnstore index is the new type of index introduced in SQL Server 2012. It is a column based non-clustered index...

2013-07-10

826 reads

Unlocking “Lock Pages in Memory” Option

Consider this scenario; Your production database server is new and with super configuration of 32 CPUs, 64G RAM, SAN Storage,...

2013-07-08

345 reads

It’s Sunday night now, weekend is almost over and was it just a few moments ago that it was Friday?...

2013-07-07

326 reads

I coach volleyball and I do a lot of stat stuff on paper. I...

dolorblindness – n. the frustration that you’ll never be able to understand another person’s...

I had a customer ask about analyzing their Test Data Manager (TDM) usage to...

Is there a good syllabus for reading these two together? (Yes, it's called the...

Comments posted to this topic are about the item GPX distance and time analysis...

Comments posted to this topic are about the item The DBA is Dead; Long...

In SQL Server 2025, if I want to remove an IP from a listener, what do I do?