Hi sanuj!

I currently have several billion+ row tables. Between partitioning and effective indexing, these tables perform pretty well. One thing to keep in mind if you...

Hi Eric,

Sorry, I had a typo. Basically, the last column showed "5" instead of "[5]", so a static value of 5 was being filled down. It's supposed to...

How about a pivot table?

Select invNo, productID, [1] As col1, [2] As col2, [3] As col3, [4] As col4, 5 As [col5]

From (

Select invNo, productID, sizeSeq,...

There's a couple of ways to handle this, but nothing that's particularly elegant. I would normally suggest handling this in the presentation layer. Nevertheless, here's a quick and...

Hi there!

From Microsoft BOL: "The CUBE operator generates a result set that is a multidimensional cube. A multidimensional cube is an expansion of fact data, or data that records individual...

I agree with Steve.

We have several billion+ row tables, and they're actually stored on the same physical drive. If you currently store your 1.3 billion row table, then you...

You mentioned a clustered index on the ID field, and a non-clustered indexed on log_time, box, and action. You then group by box and serial. Try changing your...

Hi there! I've actually worked with partitioning quite a bit. I've posted an article about some of the reasons to use partitioning, including some of the benefits and...

Hi there! Here's a link to my blog post with the script I use: Index Defrag Script. This is executed nightly on some fairly large databases with great...

Hi there. I also have a process that will defrag indexes nightly. You can find the script on my SQL blog here: http://sqlfool.com/?p=63.

Aside from that, Steve's right... data...

At one of my previous jobs where I acted as IT Admin, I would send out "critical patch" applications to users I knew could take a joke. The "patch,"...

I stayed with my previous company for 5 years. Five miserable, stress-filled years. I was afraid to leave because, at the tender age of 24, I was making...

My company actually does use its own software internally. One of its offerings is a web-based e-mail and calendar system, and all employees are "strongly encouraged" to use the...