Viewing 15 posts - 2,536 through 2,550 (of 3,061 total)
The practical benefit of partitioning by active/inactive flag would be to automatize the archiving and purging process -each time a row goes inactive it has to be phisically deleted -purge...
May 22, 2009 at 12:52 pm
Diamond Mouse (5/20/2009)Can you please explain which table can be a suitable candidate for partitioning?
As already posted you may want to consider table partitioning in one of both of the...
May 21, 2009 at 11:25 am
Tara (5/20/2009)How would i test all my scripts to check every rule in the script is working perfect.
Carefully? 🙂
Welcome to the ancient art of building a testing environment.
You have to...
May 20, 2009 at 3:23 pm
pradyothana (5/19/2009)
Need a Defragment Script with out using Cursors.
:w00t: Is perhaps Microsoft licensing "cursors" as a non-standard option now?
Don't put ideas like that one in their heads! 😀
May 19, 2009 at 12:42 pm
Most likely either a networking or application issue; check error log.
May 19, 2009 at 12:38 pm
By including functions in a query add overhead.
Picture the scenario below for a 10M rows myTable table...
select column-a
from MyTable
Query does a full table scan on 10M rows MyTable,...
May 19, 2009 at 12:33 pm
Rem (5/19/2009)What are the best practice when you have huge databases? Like Walmart for example?
Real world DWH environments do not include a "staging" database that somehow would be later...
May 19, 2009 at 8:05 am
koosubscriptions (5/18/2009)...so that I can get the exact form data at any given time.
This is what Oracle calls flashback query -a feature packed with Ora10g
Hard to accomplish such a thing...
May 19, 2009 at 7:59 am
Described scenario looks more like a reporting database than a data warehouse.
Here is where you can start.
1- Read and understand Kimball's approach.
2- Read and understand Inmon's approach.
3- Choose
4- Assuming you...
May 19, 2009 at 7:53 am
A 2M rows table can be considered a small one.
Question would be: what's the reason why you may want to partition such a table? is it performance?
Working with such a...
May 19, 2009 at 7:47 am
Switch the server -actually, switch the access path to the server.
Do not call them production and staging, call them Reporting-1 and Reporting-2.
Today Reporting-1 is exposed as production while Reporting-2 is...
May 18, 2009 at 1:26 pm
We do have a home grown monitoring application to do that -unfortunately (for you) this is propietary code so I can't share it.
On the other hand I can tell you...
May 18, 2009 at 1:20 pm
My suggestion would be to look at Data Warehouse design before looking at the ETL tools.
There are two different approaches for Data Warehouse design; the original authors are Ralph Kimball...
May 18, 2009 at 11:08 am
well... original post said nothing about a tnsnames based connection then everybody started talking about ODBC then you asked where to set some option and at that time I answered...
May 15, 2009 at 3:09 pm
I do not have my old SQL Server 7.0 scripts at hand but check what Pop Rivett has to say http://www.simple-talk.com/sql/backup-and-recovery/pop-rivetts-sql-server-faq-no.4-pop-does-log-shipping/ 😉
May 15, 2009 at 2:46 pm
Viewing 15 posts - 2,536 through 2,550 (of 3,061 total)