Viewing 15 posts - 23,506 through 23,520 (of 26,490 total)
First, question. Where is the backup file located, tape, network share (mapped drive or UNC), or a local disk?
My gut feeling, your backup is corrupt. If local tape,...
November 24, 2008 at 11:14 pm
In addition to your execute plan, we will also need to see your query and the DDL for the table including all indexes that are defined on it as well.
November 24, 2008 at 11:11 pm
Everything you posted may, in your mind be helpful, but we also need to see your stored procedure.
November 24, 2008 at 11:09 pm
Mr J (11/24/2008)
CREATE TABLE test AS
(SELECT A, MAX(B)
FROM ...
November 24, 2008 at 10:41 pm
On a personal note, this forum thread allowed me to break 3000 forum posts!
Edit: And that does NOT count this post!
November 24, 2008 at 10:30 pm
Paul Nicholson (11/24/2008)
I just realised that the server running the application is one that hasn't been upgraded to 2005 and is still running 2000 - I also noticed that there...
November 24, 2008 at 10:27 pm
Paul Nicholson (11/24/2008)
Thanks very much for your offer of assistance, below is a sample (10 rows) CSV file from the major query providing the source data. Further down is...
November 24, 2008 at 10:22 pm
To make things easier, provide me with sample data as it would come as the result of your major query, you know the one with all those left and right...
November 24, 2008 at 9:15 pm
The thing is, what I am seeing is a very procedural process. When moving to SQL, you have to change your mind set to a set based approach. ...
November 24, 2008 at 9:02 pm
Jeffrey Williams (11/24/2008)
-- CASE
SELECT CASE WHEN col1 < 50 THEN 0
WHEN col1 < 40 THEN...
November 24, 2008 at 8:29 pm
Some sample data and expected results based on the sample data would also be quite welcome.
November 24, 2008 at 8:24 pm
RBAR! You should be able to do this in a set based query. First thing to ask, WHAT are trying to accomplish, NOT HOW do you do it....
November 24, 2008 at 7:35 pm
jacroberts (11/24/2008)
timothyawiseman (11/24/2008)
jacroberts (11/24/2008)
Performance isn't always an issue as in my previous example.
I agree with Jeff that performance should always be a concern. After all, you may eventually need...
November 24, 2008 at 6:44 pm
Have you read the article about running totals that I have linked in my signature block below? If not, you might want to spend some time reading it and...
November 24, 2008 at 4:58 pm
Could you explain in greater detail what it is you want to accomplish?
November 24, 2008 at 4:56 pm
Viewing 15 posts - 23,506 through 23,520 (of 26,490 total)