Viewing 15 posts - 3,961 through 3,975 (of 18,926 total)
GilaMonster (8/2/2011)
chess.chess (8/2/2011)
GilaMonster (8/2/2011)
chess.chess (8/2/2011)
I realize that the sizes vary but I am just trying to get an idea for the average for a large application .
The point we're...
August 2, 2011 at 12:21 pm
Just use datename and update the whole table.
You'll need to set the correct us holidays as well. I've used canadian holidays here so some of them are different.
August 2, 2011 at 12:20 pm
srferson-957148 (8/2/2011)
August 2, 2011 at 12:19 pm
Can be persisted or indexed, so no "need" for trigger here. Tho I might choose that option as well.
August 2, 2011 at 12:18 pm
chess.chess (8/2/2011)
GilaMonster (8/2/2011)
chess.chess (8/2/2011)
I realize that the sizes vary but I am just trying to get an idea for the average for a large application .
The point we're trying...
August 2, 2011 at 12:15 pm
PaulB-TheOneAndOnly (8/2/2011)
chess.chess (8/2/2011)
online banking ? i.e. how many tables and MBs of data ? Just...
August 2, 2011 at 12:14 pm
GilaMonster (8/2/2011)
Ninja's_RGR'us (8/2/2011)
Biggest table I have now is around 20M rows, 2.5GB.
Biggest I've heard of was 100 000 000 000 rows (no idea of size or what it stored)
US debt...
August 2, 2011 at 12:12 pm
Sean Lange (8/2/2011)
Are you quoting me to say that my suggestion is also yours or did you forget to include your comments?
repointing to the correct answer.
Might also point out the...
August 2, 2011 at 12:11 pm
chess.chess (8/2/2011)
Thanks . Just curious .... how many tables and views would that be ?
I've seen 10K tables a few times. I've heard of 30K for SAP.
Biggest table...
August 2, 2011 at 12:05 pm
When do you plan on posting the DDL of the tables for the top 4 queries along with keys indexes and sample data. You already gave the rowcount, but...
August 2, 2011 at 12:04 pm
50 TB.
I've seen bigger data warehouses.
Why do you need to know?
August 2, 2011 at 11:59 am
PaulB-TheOneAndOnly (8/2/2011)
Roger Sabin (8/2/2011)
If I use ALTER TABLE to change the varchar size (e.g. varchar(20) to varchar(50)), SQL Server will not duplicate the table...
August 2, 2011 at 11:57 am
ROW_NUMBER() OVER(PARTITION BY Group, Date ORDER BY Whatever)
August 2, 2011 at 11:56 am
In theory it can be removed (not sure if there are bugs associated there). I don't have a list of the applications to remove but usually you can do...
August 2, 2011 at 11:54 am
Viewing 15 posts - 3,961 through 3,975 (of 18,926 total)