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

833 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

348 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

332 reads

It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...

Software is hard. While I love our Lucid Gravity, I realize that they are...

Making Data AI-Ready, Part 2 (This is the second article in a three-part series...

Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...

Comments posted to this topic are about the item Checking the Error Log II

Comments posted to this topic are about the item Parameter Sniffing on SQL Server...

What is the reason I should change my old code that uses xp_readerrorlog?