Viewing 15 posts - 46 through 60 (of 82 total)
I've found the Import/Export Tool with SQL Server 2000 to be the best tool at my disposal for extracting query results from our Oracle Server, regardless of where I need...
May 21, 2008 at 8:54 am
dporter (5/13/2008)
Thank you so much! This took about 10 seconds off of my query. Thanks! 🙂
Out of curiosity, what is the current time and what was the previous...
May 13, 2008 at 3:22 pm
Jeff Moden (5/13/2008)
Why do you need a Cross-Join on the @DistinctQuarters table?
From my read of the code, it appeared to be storing (or intended to store) multiple time frames, with...
May 13, 2008 at 3:18 pm
Danielle:
Don't bother with the loop at all, substitute in a join.
----Segment Level Supply
INSERT INTO @ConversionTesting(Quarter, Source, Segment, Metric,Value)
select Q.Quarter, 'Converted' as Source, MarketsegmenttypeCode, 'Inventory', sum(NumUnits)
from dbo.tbl_BldgSegments bs
inner...
May 13, 2008 at 11:12 am
jburkman (5/13/2008)
Ok, so I guess I'm the only one who doesn't get this part, but:
in
SELECT TOP 11000 --equates to more than 30 years of dates ...
May 13, 2008 at 9:16 am
Kevin Mao (5/9/2008)
Wow, that's great.For the first extended store procedure xp_fileexist which exists in Sql 2000. Others are new in SQL 2005.
Are you sure? I'm able to...
May 9, 2008 at 12:38 pm
RyanRandall (5/9/2008)
update hshah.dbo.currentmembership set
[memblname] = replace(replace(replace([memblname], ' ', ' |'), '| ', ''), '|',...
May 9, 2008 at 10:19 am
I'm trying, but can't figure out how to apply this to cleaning user input. I have a file I get monthly with member information that has some rows which...
May 9, 2008 at 9:46 am
Jeff Moden (5/9/2008)
One reason might be, you can't TRUNCATE if FK is present... heh, of course, that also means you need to delete in the correct table order.
Would using sp_MSdependencies...
May 9, 2008 at 9:35 am
One comment:
exec dbo.sp_msforeachtable 'delete test.dbo.[?]'
There's generally no need to do a delete without criteria, as truncate will perform better with less logging:
exec dbo.sp_msforeachtable 'truncate table test.dbo.[?]'
That said, I'm sure it...
May 9, 2008 at 9:09 am
Trace Herrell (5/5/2008)
This will not compile in SQL 2005....Conversion failed when converting the varchar value 'B' to data type int.
On the contrary, it did compile but it encountered an error...
May 5, 2008 at 1:27 pm
I have 2000, and it gave the "correct" result for me.
May 5, 2008 at 6:56 am
This site (link) states that DB2 only guarantees that a clustered index is initially clustered, clustering is not maintained. While this saves time on inserts (no page splits), I'm...
April 15, 2008 at 9:45 am
This sounds like unclustered indexes on a grouped heap. Granted, grouping the heap is an interesting idea, but I wouldn't call it multiple clustered indices.
April 15, 2008 at 9:12 am
EdVassie (4/15/2008)
April 15, 2008 at 7:13 am
Viewing 15 posts - 46 through 60 (of 82 total)