How to load data effectively?

With this post I would like to share with you some results of my own, limited data load performance tests. Even based on this narrow and platform-specific test general conclusion could be drawn, I think. Configuration Test server was HP Proliant DL580G8 equipped with 2 Intel E7 processors, 256 GB RAM and EMC VNX 5600 [...]

Indexed Computed Columns and DBCC CHECKDB

Recently I spoke a couple times about using indices to solve some otherwise unsolvable performance problems, like turning non-searchable arguments into SARG ones. Now it’s time to point out a hidden cost of this solution — incredibly slow database consistency check. Problem Let me illustrate this problem with a sample database I used i.e. at [...]

Indexed Views. Part 1. The Benefits

Indices serve three main purposes: 1. They are used to limit (or minimize) the amount of data being read to execute queries. 2. They can eliminate costly operators (like sort or aggregate) from query execution plans. 3. Finally, they can tremendously improve concurrency. On the other hand, indices aren’t free — not only they take [...]

The Case of VARCHAR(4), or when you should not use a variable length column?

Have you ever consider using VARCHAR(4) or similar data type? If so, you really should read this post. If not, please continue reading and find out why you were right. Don’t be cheap on data types SQL Server, at least until SQL Server’s 2014, reads and writes whole pages (8-KB blocks of data), neither rows [...]