Viewing 15 posts - 21,391 through 21,405 (of 26,490 total)
Instead of searching through 300+ posts, could we get bruce t's problem posted to a new forum thread and a link added here for anyone interested to follow to that...
April 20, 2009 at 8:22 pm
Is there more to the real world data that would support the sequence of data entered? is there a date field or other form of identification that signifies the...
April 20, 2009 at 8:08 pm
Goldie Graber (4/20/2009)
It works well on tables with up to a few million records. Takes a minute or two.
When I had...
April 20, 2009 at 8:04 pm
Mr Dassin,
You really have missed the point. Stop with the hyperbole and attacks on SQL Server (and all its cousins). Provide straight, well supported facts. Provide actual...
April 20, 2009 at 7:59 pm
Paul White (4/20/2009)
dphillips (4/20/2009)
And by the way Steve Dassin, you may want to go re-read Snarky's comments.Let it go dude 🙂
ooommmmmmmmmmmmmmmm
April 20, 2009 at 4:33 pm
Looking at the code and such, I think I know what is going on. Can you post the actual execution plan for the query? I suspect that your...
April 20, 2009 at 4:26 pm
I still need to see your query as well. I need to see how the tables are being joined together.
Also, are there any other indexes on the tables?
April 20, 2009 at 3:15 pm
If I am going to try and see what I can do, having sample data and expected results based on that sample data is important. How do I know...
April 20, 2009 at 3:08 pm
Since you did manage to "accidently" post your question, it would also be nice if you could post your resolution as well. Someone else may have a similar problem...
April 20, 2009 at 2:57 pm
FYI, the sample data for dbo.BackgroundViews does not have any data that matches the sample data for dbo.IPCITYISP.
April 20, 2009 at 2:35 pm
Could you post your code as well? I wouldn't be surprised if the problem with performance is actually related to your scalar function for converting the IP address.
April 20, 2009 at 1:56 pm
Can you also post the DDL for the tables (including indexes) and the query that you are running?
April 20, 2009 at 1:51 pm
Dave Hoogendoorn (4/20/2009)
Regarding the validity of the test;I agree. However. Before the issues started, the queries were much, much faster then those 2...
April 20, 2009 at 1:38 pm
Dave Klug (4/20/2009)
Initial size is 48,000 MB, not GB.
48,000 MB is approximately 48 GB. If the disk you are trying to create tempdb on is only 50 GB in...
April 20, 2009 at 1:09 pm
Would you please post the DDL for the base tables including indexes, some sample data for both tables (in a readily consumable format that can be cut, paste, and run...
April 20, 2009 at 1:00 pm
Viewing 15 posts - 21,391 through 21,405 (of 26,490 total)