Can partitioning solve it all?

Recently I got a question:

We are thinking to use partitioning for our DW database, since we have monthly incoming data of 30 million rows and partitioning will make the reads and writes much faster; we are using a 2 CPU machine with 16 Gb, 2 hard drives of 500Gb each.

Could you recommend a good strategy

Continue reading […] Can partitioning solve it all? […]

 

Where do you get your SQL Server knowledge?

Lately I have been wondering: if there is too much information everywhere, how do we know what to get, how to filter it and what to make out of it? (just imagine a chicken, swimming in a sea of all kinds of seeds – corn, sunflower, rye… how does the chicken choose?

Continue reading […] Where do you get your SQL Server knowledge? […]

 

What’s Causing Files to Automatically Grow

Recently I read a blog post on What’s Causing Files to Automatically Grow and I am wondering if there is a way to actually capture the forced (non-automatic, on-demand) growth of files.

I did some tests (correct me if I am wrong!) and I noticed that the following Profiler events

Event 92 = Data file auto growth

Continue reading […] What’s Causing Files to Automatically Grow […]