Topics
Started by
Posts
Last post
Our database is about 100 megs, and the transaction log was 9 gigs. After complains that the server…
4 replies
Hi there, Please can anyone shed any light or suggestions on my problem: I have two tables, one is …
2 replies
hi there, I hv a proc which uses lot of temp tables and few cursors . I hv use DML and DD…
6 replies
Hi Guys... whats up... got a problem here... I Have 3.6 million of records in 2 tables... and …
3 replies
I don't know why. But i have a Sql Server 2000 with service pack3 and my table sysperfinfo is empty…
1 replies
I noticed in Profiler that Show Plan Statistics/Show Plan All are available. However, when I select…
2 replies
I use Profiler to track database and server activity currently. I record the results in data files.…
1 replies
I have a database that I am monitoring, using Profiler, to see what errors and warnings are found.&…
1 replies
Can anyone please let me know if by running backup jobs does a server get impacted in terms of perf…
5 replies
How do you read an Execution Plan for a Query displayed in Query Analyzer? I know that I have to re…
5 replies
Hi all. Just a quick one. I have a basic query against a 1M+ row table. select count(*)…
1 replies
I am working with SQL 7 service pack 4.0. and are running several stored procedures through Sql Ser…
5 replies
HI, This was a question that I was asked and I was hoping to get some input from you guys.&n…
2 replies
Hi, I noticed very different performance of these two statements that returns the same recordset: F…
2 replies
Hi All, I have a table (say Table1) with around 182,000 records and it has about 64 rows. Differenc…
1 replies
Viewing 15 topics - 1,771 through 1,785 (of 2,580 total)
You must be logged in to create new topics.