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

We had an interesting discussion about deployments in databases and how you go forward...

You could be tolerating limited reporting because there isn’t an off the shelf solution...

A while back I wrote a quick post on setting up key mappings in...

We want to setup a gateway db to host stored procedures which use tables...

Comments posted to this topic are about the item Lots of FKs

Comments posted to this topic are about the item Real-time On-prem SQL Server Data...

In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?