Topics
Started by
Posts
Last post
I have a stored procedure that jumps from 1000 CPU in profiler to 5000 CPU and stays there. If I re…
6 replies
Hi all, We have an SQL 2000 Standard SP4 system with 3gb of RAM running on Windows 2003 Server R2 S…
7 replies
Hi... According to requirement I have to take 1000 fields in column1 of Table1 and pass those field…
3 replies
Thanks for all your replies. Cheers, Sugeshkumar Rajendran SQL Server MVP http://sugeshkr.blogspot.…
12 replies
Hi All, We've tested following INSERT SQL as a part of simple load testing. Machine configuration: …
7 replies
Hi , In my procedures i am using temporary tables to store intermediate results. I am creating temp…
11 replies
Hi , In my recent procedure , I am using lot of local variables to store intermediate values. will…
3 replies
Dear All, We are implementing the NETAPP SAN that has a RAID-DP (Dual Parity - will work even if 2 …
13 replies
We have a 30 GB database with both the auto-grow and auto-shrink options turned on. I know th…
1 replies
I'm doing a lot of performance tuning on the stored procedures in our system, and have been noticin…
10 replies
Hello, Does anyone have any info on sysperfinfo, particularly buffer cache hit ratio? Does this rep…
5 replies
Hi, Can any one help me out to improve the performance of the below query, SELECT DISTINCT INTNL_…
15 replies
Hi all, Using SQL2K SP2 on Win2K SP4. Got a strange problem: Each night, we transfer all prod DBs t…
13 replies
This sql 2k proc below is called by our client's VB rate feed process. When the market is very…
11 replies
We are displaying data for orders per customer in a new application we are developing. We have two …
5 replies
Viewing 15 topics - 766 through 780 (of 2,581 total)
You must be logged in to create new topics.