Forum Replies Created

Viewing 15 posts - 436 through 450 (of 529 total)

  • RE: If PK is a GUID, what index type is best?

    Antares:

    I forgot to mention that your demonstration was exceptionally exhaustive and nice 🙂

    Regards, Hans!

  • RE: If PK is a GUID, what index type is best?

    Just wanted to flash around some interesting definitions from BOL:

    quote:


    Nonclustered indexes can be defined on a table with a clustered index,...

  • RE: Primary Key constraint

    Jeff:

    1) If you already have a staging table, you do not have to create an additional one 😉

    2) If you are directly BCPing in your data into your table without...

  • RE: Best practice when to use an index

    Hello Everyone!

    quote:


    Can we come over to conclude, that Identities CAN make life easier, but MUST NOT neccessarily and that they...

  • RE: Best practice when to use an index

    Hello Frank 🙂

    Well, don't get me wrong. I also like joining on INTs. But the case of always using your IDENT as your PK seems to me like a waste,...

  • RE: Best practice when to use an index

    Mikey:

    If you are joining tabA with tabB ON tabA.[Date] BETWEEN tabB.StartDate AND tabB.EndDate I have absolutly no problem whatsoever. I do not see any reason for not doing that...

  • RE: Indexing Problems

    Have you any indices on tblLine (on site_fk for example :-)?

    How UNIQUE are the different sites in the tblLine? I.e how many DISTINCT site_fk's do you have compared to...

  • RE: Best practice when to use an index

    David:

    quote:


    My identity column is ALWAYS my primary key, otherwise there would be no point in having it.


    July 9, 2003 at 2:51 pm

    #464746

  • RE: Indexes

    ...sp_MSforeachdb

    ...sp_MSforeachtable

    /Hans

  • RE: How many records can SQL Server handle?

    Interesting note:

    * When creating a non-unique clustered index on a table, MSSQL adds a UNIQUE value to the non-unique data to make it unique.

    Somewhere in BOL I read that this...

  • RE: Trigger on Schema ???

    Here is another tip I would warmly recommend (I am in no way associated with Lumigent but I have a strong liking for this product) as it is very easy-to-use...

  • RE: Does Reorg unload/reload data?

    quote:


    I'll identify fragmented tables using DBCC SHOWCONTIG (Scan Density); then drop and recreate any clustered index (or create a new clustered index)
  • RE: Does Reorg unload/reload data?

    jguff: Please keep the same question in one topic.

  • RE: Case-sensitive issue

    How about keeping the DB Case-Insensitive but collate all your tables (when creating) into your case sensitive version?

    /Hans

  • RE: Collation settings

    Anyone knows the difference between some of the different collations?

    For example

    SQL_Latin1_General_CP1_CI_AS vs Latin1_General_CI_AS

    Anyone did some performance checks between types of collations? How much faster is CS vs CI and...

Viewing 15 posts - 436 through 450 (of 529 total)