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

Do you spend so long manipulating your data into something vaguely useful that you...

It was neat to stumble on this in the book, a piece by me,...

Forgive me for the title. Mentally I’m 12. When I started my current day...

Comments posted to this topic are about the item Microsoft Security Changes and SQL...

Comments posted to this topic are about the item Expanding into Print

Comments posted to this topic are about the item Downtime Caused by the Postgres...

In SQL Server 2025, what is returned by this code:

SELECT EDIT_DISTANCE('Steve', 'Stan')

Assume preview features are enabled.