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

827 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

327 reads

I have a presentation on finding balance in your career that got quite a...

But as I've matured over the years, I came to realize that I needed...

I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...

The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...

can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...

I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...

Which movie featured this quote?

"All programs have a desire to be useful."

Happy April Fools!