Viewing 15 posts - 2,371 through 2,385 (of 3,616 total)
Never mind the features, why is SQL Management Studio so pathetically slow!
Even if you put the -nosplash switch on the SQLWB.EXE it takes an age to load.
There are bits I...
March 16, 2006 at 4:39 am
Definitely fixed growth.
I would try and size it so that an autogrow isn't going to happen unexpectedly.
I would also check out the settings for TEMPDB. Unless you have changed...
March 13, 2006 at 8:10 am
It is doing a bit comparison of a value.
If you think of an 8 bit number then
Bit 1 = 1
Bit 2 = 2
Bit 3 = 4
Bit 4 = 8
Bit...
March 10, 2006 at 12:51 pm
The latest release has Triggers, stored procs, DRI, support for clustering etc.
Well worth a look even if it is just as the icing on top of a CV.
March 9, 2006 at 12:35 pm
I worked briefly with an old neural net called 4Thought.
It "learnt" from the data that was supplied to it but it really was a garbage in garbage out thing.
I used...
March 8, 2006 at 11:01 am
No abscence of DRI does not hurt performance it merely makes it possible to create a situation where you have orphaned records. It does not automatically mean that orphaned...
March 8, 2006 at 10:48 am
Yes but as I said, the performance hit is as a result of not having DRI in the database and this resulting in orphaned records.
DRI does not affect SELECT statements...
March 6, 2006 at 4:06 pm
Thanks, the bit meaning is more robust than relying on naming conventions.
The query I was basing my work on was
select object_name(fkeyid)AS ReferencingTable,object_name(rkeyid) AS PrimaryTable,object_name(constid)AS FKName,c1.name AS ReferencingColumn,c2.name AS ReferencedColumn
from...
March 6, 2006 at 1:48 pm
If you were going to match up Customer to Orders anyway then DRI should have no affect.
If all you wanted were Orders without the customer information then having to...
March 6, 2006 at 12:35 pm
Do you happen to know what the bit flag is?
What I am trying to do is write a query that will find out when a foreign key constraint isn't supported...
March 6, 2006 at 12:28 pm
I am trying to make the distinction between entries created by CREATE INDEX vs those created by CREATE STATISTICS.
I know that the _WA_SYS entries are where SQL Server itself generates...
March 6, 2006 at 11:41 am
DRI does not impact performance of SELECTs directly.
Indirectly its absence might because you are trawling through more (orphaned) records to achieve a stated goal.
If the query uses INNER JOINS it...
March 6, 2006 at 2:07 am
Look in BOL for the -h hint. This lets you specify how many records are uploaded at once.
I've just had to run a 220,000,000 record upload and I would...
March 3, 2006 at 12:59 pm
Spot on DC Peterson!
The design of the real package is very similar to my example.
A CommonObject held about 50 fields that were common for any single specific table no matter...
March 3, 2006 at 9:44 am
Just as a matter of interest what design would you put in place instead of the example given?
March 3, 2006 at 7:49 am
Viewing 15 posts - 2,371 through 2,385 (of 3,616 total)