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

821 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

337 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

323 reads

amoransia – n. the melodramatic thrill of unrequited love; the longing to pine for...

One of the things that I like about the Data API Builder (DAB) is...

Hey data friends! This blog is to discuss an edge case I’ve run into...

How it is implemented? I have installed, tried, it is free for dbs <=30...

Comments posted to this topic are about the item Technical Pain Behaviors

Hello, trying to call a powershell file I created, locally on the server, but...

What does the BIT_COUNT function do in SQL Server?