hi Andy,

We have several tables above the 10 billion rows mark. Luckily we have the Enterprise Edition, so we have been able to partition the tables.

That helps maintainability, it does...

thank you very much

Hi Sean,

May I suggest that you take a look at http://sommarskog.se/

His section on dynamic search conditions is long, but worth-while reading.

Best regards,

Henrik

Hi Steve,

I think the answer should state that it is a lot safer to just write "DayOfYear" in your code.

This also makes the code easier to read.

Best regards,

Henrik

So is this what is needed?

well, I could also do this:

CREATE TABLE dbo.Test

(

...

Hi Gail,

Unfortunately the Compress keyword is an Enterprise Only feature.

It is only backup compression that is in the standard product.

This code runs on 1400 SQL Servers, so upgrading is not...

Hi Gail,

Unfortunately the table has over 300 column, where most are FLOATs or Decimals.

We have investigated if we could do such a split table exercise, but we haven't found a...

hi Gail,

Thank you very much for writing back so quickly.

<<I liked your solution for physical fragmentation (rebuilding the indexes into a secondary partition)

That is what we normally do...

Hi Gail,

I've just found that a lot of our databases have had the same setting.

They are on small servers, with RAID 5 or RAID 10.

I know we could fix the...

Hi Mauricio,

I've just issued such a command;

ALTER TABLE dbo.VMPGlobalLogArgument ADD VMPGlobalLogArgumentID BIGint NOT NULL IDENTITY (1, 1)

on a table with 1.4 billion rows.

This time I can afford the down...

Hi Mario17,

Why do you want to use RAISERROR, when you're using THROW?

Best regards,

Henrik

hi Brian,

Are you aware that SQL Server 2014 will have statistics by partitions?

We expect that will help us tremendously.

Also, I've found this video very useful: http://technet.microsoft.com/en-us/sqlserver/gg545008.aspx

It can be found together...

hi Nicholas,

I've found a problem when sum(Size) is too big to fit into an integer.

Here is the fix:

Best regards,

Henrik

SET NOCOUNT ON

/*

Author:Nicholas Williams

Date:3rd February 2008

Desc:Calculates Growth Info for all databases on...

Hi Miles, Howard,

A very good idea that I'll look at on Monday.

Last time I looked, there were a limit at 15 TB, but that is quite some time ago....

Hi all,

@steve-2:

yes, and we do that on the production server.

The only solution is to...