Viewing 15 posts - 7,051 through 7,065 (of 7,636 total)
The problem with the phrase "Remove Duplicates" is that the speaker *usually* means is "one of them is 'real', so the others that are like it are the duplicates, so...
April 30, 2008 at 1:21 pm
I would just make a "Color" column that is NULL unless TypeFactor=1 and a Size table that is NULL unless TypeFactor=2, etc. I definitely wouldn't recommend a ColorOrSize column.
April 30, 2008 at 1:10 pm
matt6749 (4/30/2008)
someone in another forum said the dynamic sql version (the 2nd one) was clearly faster/better
Similar claim was made here. Point me to it and I will take a look...
April 30, 2008 at 11:28 am
matt6749 (4/30/2008)
another article compares four methods:http://www.codeproject.com/KB/aspnet/PagingLarge.aspx
Conclusion: "The methods performed in the following order, starting from the best one - RowCount, Cursor, Asc-Desc and Subquery."
OK, I skimmed that article, at lot...
April 30, 2008 at 11:25 am
Matt Miller (4/29/2008)
rbarryyoung (4/29/2008)
RBYoung (4/29/2008)
April 30, 2008 at 11:09 am
Mahesh Bote (4/28/2008)
[font="Verdana"]Second approach is much better than first one. It will decrease the network traffic tremendously.[/font]
I'm not sure that I follow this, Mahesh. Could you explain why?
April 30, 2008 at 9:12 am
There is not that much difference between them, performance-wise.
The first one is clearly older as it uses the deprecated SET ROWCOUNT XX (this should be changed to TOP XX instead).
The...
April 30, 2008 at 9:11 am
Caches may not be loaded on the rarely used DB.
April 29, 2008 at 11:41 am
Jeff Moden (4/29/2008)
--===== Create a table to demo with
DECLARE @DemoTable TABLE (IPAddr VARCHAR(15))
INSERT INTO @DemoTable (IPAddr)
SELECT '192.168.215.1' UNION ALL
SELECT '192.168.23.1' UNION ALL
SELECT '192.168.5.1'...
April 29, 2008 at 11:27 am
I think that the closest that you could get to this would be an in-line table-valued function. Instead of using IF .. BEGIN.. SELECT.., you would put the IF...
April 29, 2008 at 11:22 am
Jeff Moden (4/26/2008)
Lynn (4/24/2008)
I can't put these tables in a separate db because the application will break.
Oh, yes you can... put the tables in a different DB and either make...
April 29, 2008 at 11:07 am
The SOP way is something like:
Select distinct * into #tmp From SC
Truncate Table SC
Insert into SC Select * from #tmp
Drop table #tmp
You also might want to wrap this in a...
April 29, 2008 at 10:34 am
RBYoung (4/29/2008)
April 29, 2008 at 10:09 am
Parthipan: How did this work out for you?
April 28, 2008 at 8:43 am
InfoPath? It's got a lot of limitations, though. Unless you use code-behined, but that of course takes you back to C# and VB.net.
April 27, 2008 at 11:52 pm
Viewing 15 posts - 7,051 through 7,065 (of 7,636 total)