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

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

Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...

I hosted this month, late as it turns out, but we still had a...

I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...

Comments posted to this topic are about the item Create an HTML Report on...

While doing some housekeeping activity on several old but large production databases, I come...

How important to SQL Server is the speed of the SSD and network latency?...

In SQL Server 2022, how many backup files can I have in a striped backup?