Viewing 15 posts - 436 through 450 (of 529 total)
Antares:
I forgot to mention that your demonstration was exceptionally exhaustive and nice 🙂
Regards, Hans!
July 11, 2003 at 4:43 am
Just wanted to flash around some interesting definitions from BOL:
quote:
Nonclustered indexes can be defined on a table with a clustered index,...
July 11, 2003 at 4:36 am
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...
July 10, 2003 at 10:30 am
Hello Everyone!
quote:
Can we come over to conclude, that Identities CAN make life easier, but MUST NOT neccessarily and that they...
July 10, 2003 at 6:20 am
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,...
July 10, 2003 at 4:13 am
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...
July 10, 2003 at 2:10 am
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...
July 9, 2003 at 3:06 pm
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
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...
July 9, 2003 at 9:58 am
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...
July 1, 2003 at 9:39 am
quote:
I'll identify fragmented tables using DBCC SHOWCONTIG (Scan Density); then drop and recreate any clustered index (or create a new clustered index)
June 27, 2003 at 10:04 am
jguff: Please keep the same question in one topic.
June 27, 2003 at 5:42 am
How about keeping the DB Case-Insensitive but collate all your tables (when creating) into your case sensitive version?
/Hans
June 27, 2003 at 4:28 am
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...
June 27, 2003 at 3:47 am
Viewing 15 posts - 436 through 450 (of 529 total)