Viewing 15 posts - 2,266 through 2,280 (of 3,061 total)
DBArtisan.
We run Oracle, Sybase and SQL Server in our shop; DBArtisan makes our lives easier in each one of the three environments.
October 27, 2009 at 2:56 pm
Monitoring Service Broker?
I would start here http://msdn.microsoft.com/en-us/library/ms166069(SQL.90).aspx
October 27, 2009 at 1:30 pm
My money is with ERWin; be sure you get the yourBrain plugin working with it 😀
October 27, 2009 at 12:55 pm
Put an index on the flag column, schedule a job to run every other minute then let scheduled job look for the rows that are ready to move... and move...
October 27, 2009 at 12:34 pm
Chances are there are 266 matching rows on pymt table, isn't it?
October 22, 2009 at 1:21 pm
is Oracle server local or remote?
how many network hops?
bandwith?
latency?
how complex is the query reading from SQL Server?
post offending query execution plan.
October 16, 2009 at 8:13 am
:blink: now I'm confused.
If partitioning strategy is not designed to help archiving/purging and at the same time is hurting performance... why partitioning?
October 9, 2009 at 3:37 pm
Assuming SS2K5 statement below should do the trick...
select is_identity, count(*) from sys.columns group by sys.columns.is_identity
0 => Disabled
1 => Enabled
October 9, 2009 at 2:51 pm
Two solutions...
1) Application in database A knows when a row is ready to be "moved" to database B, isn't it?... so, let application in database A connect to database B...
October 9, 2009 at 2:31 pm
Marios Philippopoulos (10/2/2009)Why replace the SQL native functionality for backups with a 3rd party tool, especially if you are already using SQL Server 2008 Enterprise Edition (which comes with a...
October 9, 2009 at 2:23 pm
ed-1075072 (10/8/2009)
... or for all the mentioned fields such as SSN, Salary info?
all columns you want to protect.
October 9, 2009 at 2:17 pm
Since your "PartitionTable is partitioned on a non-PK column" your PK could not be clustered. Easy as that.
If in that scenario a non-clusterd PK proves to have a negative effect...
October 9, 2009 at 2:11 pm
EdVassie (9/25/2009)
If both approaches work 100% of the time then the risks are the same so the focus moves to costs.
mmmhhh... There is not such a thing as a...
October 2, 2009 at 7:53 am
David. (9/25/2009)
For our data acquisition systems, all are at 3rd level normalization.Our data warehouse uses the Kimball Star Schema design.
I'm in full agreement with David's post above.
In regards...
October 2, 2009 at 7:19 am
Viewing 15 posts - 2,266 through 2,280 (of 3,061 total)