Topics
Started by
Posts
Last post
Hi, I'm in the process of trying to optomise some search queries and was looking for some he…
2 replies
Hi, We are having a problem with server speed. On investigation, I see that there are quite a numbe…
2 replies
OK, I admit this is an old-fashioned way to make a CPU busy. When I run the following program, my S…
1 replies
What circumstances would warrant creating non clustered primary keys? I have seen this in some of o…
6 replies
I have 2 SQL 2000 Servers running Windows 2003 Server. Both are used heavily on a daily basis…
2 replies
Can anyone tell me why this first stored procedure is about 5 time slower than the second one? I wo…
1 replies
Hi Gurus, I am using default READ COMMITED isolation level . While inserting a single row in a tabl…
6 replies
Dear all, now we finally got the 2-Xeon Hyperthreading Server, but SQL Server 2000 does not use its…
4 replies
In the SQL Server 2000 for experienced DBAs book mentioned about monitoring db size growth, so we c…
4 replies
I am updating a bit field in a table with 4.5 million rows (row length 3017 bytes, 60%+ varchar fie…
6 replies
In the database for a CMS there are tables where the primary key is a compound of 4 integer fields.…
3 replies
Hello!!! I have a SQL 2000 Standard Edition (SP3) installed on a Win2000 server (SP4 with Patches)…
5 replies
Dear Forum, "in the old days", a program used 100% CPU while it was running unless it had to do I/O…
3 replies
In SQL 7.0, I loaded a new table with data, then added a clustered composite primary key with noche…
1 replies
Do you enable parallel execution in SQL Server on your OLTP and OLAP system? Do you see any benefit…
7 replies
Viewing 15 topics - 1,951 through 1,965 (of 2,581 total)
You must be logged in to create new topics.