Viewing 15 posts - 2,641 through 2,655 (of 3,061 total)
yulichka (4/13/2009)
For the server what is better to use delete or truncate. I know truncate (deletes data faster) and delete slower, but for the performance what is better?
:w00t:
With all due...
April 13, 2009 at 5:40 pm
SA (4/10/2009)
April 10, 2009 at 9:30 am
ms (2/17/2009)
I guess there is no easy way to do this.Thanks for the suggestions!
You are correct, not easy way to do it.
The bright side is that it will look great...
April 10, 2009 at 9:26 am
That was fast Krishna 😀 100% agreed.
Sangeetha --
I still think you have to ask those questions to yourself -see my previous post.
April 8, 2009 at 8:23 am
The key part of your post is "...slow last night".
How has this process behaved in the past?... ask these questions to yourself:
1) Does this process always takes the...
April 8, 2009 at 7:52 am
... not to mention CPU, Memory, Storage and Connectivity 😀
April 7, 2009 at 1:29 pm
Your result set will show the fourth column as "TOTAL_PRICE" because this is the label you used in the first query. Data from your second query will be there...
April 7, 2009 at 1:26 pm
wmt (4/2/2009)
thanks for that. I don't think the Oracle client for 9 will work with a 7 database however. The highest I could get to work was 8.
You are correct,...
April 4, 2009 at 2:55 pm
Shall we understand each one of you customers has access to any and all the "databases" of all your customers with dbo rights?
April 4, 2009 at 2:50 pm
RBAK (3/31/2009)
What are all the server environments(like PRODUCTION server, DEVELOPMENT server & TEST server) available with SQL server and what is the difference between them?
You may want to check...
April 1, 2009 at 8:24 am
Is this a newly acquired behavior or application has always behaved this way?
In principle, adding locking is just going to add issues.
Why don't you trace the offending query and check...
April 1, 2009 at 8:20 am
I'm 100% in agreement with Gianluca, to implement an Archive and Purge process nothing beats table partitioning.
Just archive the appropriate partition and get rid of it, that's fast, safe and...
March 31, 2009 at 5:52 am
Have you gathered fresh performance stats on SQL Server 2005 or are you running on the old SQL Server 2000 ones?
In my experience SS2005 doesn't like SS2000 stats.
March 30, 2009 at 3:10 pm
Software installation involves a little more of just making a copy of exe files.
Why don't you download it from Microsoft then proceed with a normal installation?
March 30, 2009 at 2:16 pm
Viewing 15 posts - 2,641 through 2,655 (of 3,061 total)