Forum Replies Created

Viewing 15 posts - 2,371 through 2,385 (of 3,616 total)

  • RE: SQL 2000 to SQL 2005: Where have all the old features gone?

    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...

  • RE: AutoGrow Feature

    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...

  • RE: sysindexes STATISTICS and INDEXES

    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...

  • RE: The Pitfalls of Foreign Keys

    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.

  • RE: Data Mining

    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...

  • RE: The Pitfalls of Foreign Keys

    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...

  • RE: The Pitfalls of Foreign Keys

    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...

  • RE: sysindexes STATISTICS and INDEXES

    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...

  • RE: The Pitfalls of Foreign Keys

    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...

  • RE: sysindexes STATISTICS and INDEXES

    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...

  • RE: sysindexes STATISTICS and INDEXES

    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...

  • RE: The Pitfalls of Foreign Keys

    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...

  • RE: bcp question

    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...

  • RE: The Pitfalls of Foreign Keys

    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...

  • RE: The Pitfalls of Foreign Keys

    Just as a matter of interest what design would you put in place instead of the example given?

Viewing 15 posts - 2,371 through 2,385 (of 3,616 total)