I’m Carla Abanes, working as a full time Senior SQL Database Administrator here in Singapore for an established financial trading firm.

70-457 Reviewer #02, What is Columnstore Index?

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

346 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

328 reads

The DBA life is fraught with pain. Those battles that we endure are mostly...

Every PostgreSQL migration eventually hits the same fork in the road. The database is...

I’m off on vacation today. Which is a little weird as I just got...

Hello, I would like to ask whether it is technically possible to redirect a...

Comments posted to this topic are about the item Calculating Geometric Mean in Power...

Comments posted to this topic are about the item TempDB Facts I

Can I set Accelerated Database Recovery on tempdb?