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

825 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

341 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

325 reads

SQL Server Management Studio (SSMS) has recently added support for Github Copilot. This is...

If it fails where you thought it would fail that is not a failure....

Quite a long title for a short blog post ??While deploying a DACPAC (from...

Comments posted to this topic are about the item Don't Create Workslop

Comments posted to this topic are about the item What is the original database...

Comments posted to this topic are about the item The DBScan algorithm tutorial

What is returned when this code is run?

SELECT ORIGINAL_DB_NAME()