Topics
Started by
Posts
Last post
Hi, Usually using batch updates in jdbc improves performance. But in our case, we trying to update …
3 replies
We are running SQL server on a quad processor machine with 3 Gb of memory. We are facing the proble…
2 replies
I'm wanting to load a table variable with a query result set ... and then pass the table variable t…
5 replies
Hello, Anybody else experience performance problems when using the "new" datatype table in SqlServe…
6 replies
Hi! I had a server 6xP-III Xeon 700 2MB / 4GB RAM etc. Before going to a new server I had the follo…
22 replies
I have problems with a sqlserver 7 machine with 4 processors and queries running very slowly becaus…
2 replies
What does the following waitresources from sysprocesses mean: TAB: 29:219147826 [[COMPILE]] and 29:…
1 replies
Hi, I have a big query with two correlated subqueries in it.Sql server's execution plan shows th…
4 replies
We just purchased a CX400 EMC SAN from Dell and put our PeopleSoft SQL2k database on it. The perfor…
3 replies
We're running SQL2K on a Win2K server, dual processor, 2Gb memory, blah blah The database serves it…
9 replies
The event Lock-Timeout of section Locks provides minimal information about the specific SQL. How ca…
1 replies
The configuration of my prod and test servers are the same, both 2 cpu's. The same query takes 10 …
4 replies
I'm hoping someone can help me. I was wondering if there is any potential performance issues with h…
2 replies
Hi What order does bcp output its data? e.g. bcp <table> out <filename> -T -S. -N Is th…
1 replies
we have a query that aggregates data ready for reporting on in our MIS system. It ran in approx 30…
15 replies
Viewing 15 topics - 2,041 through 2,055 (of 2,581 total)
You must be logged in to create new topics.