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

on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...

I have been active in the data community throughout my career. I have met...

Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...

I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...

hi, in an ssis for each loop over an object variable called MyListVariable, i...

SQL Server is typically viewed as a transactional or analytical database engine. However, it...

On SQL Server 2025, when I run this, what is returned?

SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL')