I'm looking at setting up a SQL Server 2005 app that deals with a very write
intensive system . Currently , it's a very simple table structure , TableA,
Table B, Table C . No indexes.I haven't sent the DDL , as I'm researching
general strategies for very write intensive systems

We have an application that uses SQL for its database.  How do we determine
the transaction load that our application is placing on the SQL Server?

I am running into a situation where CPU utilization is 95-100% and I am
curious the best way to locate the spids and ultimately the query(s) that
might be causing this.
Currently I am using the following query to pull out who the biggest user of

I am experiencing performance issues with a clients server, typical to the
posting "SQL2005 Memory Question Again" post.  Here is a summary of my
clients sql 2005 server which is used for nothing other then serving up sql
databases:

The following query sometimes takes 29 seconds to execute, performs 36
million reads and uses about 29 thousand CPU
--------
SELECT COUNT(DISTINCT [LT].[Id]) NumberOf FROM

Just wondering if anyone can think of any reasons that a switch from MSDE to
SQL 20005 on a desktop computer would result in very significant performance
problems.  Stored procs that ran just fine in MSDE are consistently running
very slowly in SQL 2005.  My DB is very small... ...

I was wondering if anyone knows a way to retrieve index and / or table
usage (#hits, #reads, #inserts, #Bytes read/write etc) from a SQL 2000 DB?
And yes, i know, I KNOW, SQL 2005 has a solution for that, but in the real
world we have customers who use a server / software combo ...

I am troubleshooting a problem in our database.  I set up SQL Server
Profiler, to profile the area in question.  I then took the trace file, and
tried to run it through the Database Engine Tuning Advisor.  The calls to
the stored procedure with the issue is getting a syntax error ...

Hi,
I migrated two 110 Gigabyte databases from SQL Server 2000 to SQL Server
2005 some weeks ago. The server with the SQL2000 databases still exists. It
is a data warehouse database, thus data is updated once a day by ETL

Hi everyone. I need to look differences between using GUID and ID as key of
my tables. I have two tables without primary key on them. Both have 100 000
records and the varchar value is full (6000 characters)
CREATE TABLE TableInt (id INT IDENTITY(1,1), column1 VARCHAR(6000) NOT ...

Hell all,
I'm being told that HP recommends a creating Virtual Disks on a single Disg
Group on the SAN, instead of traditional RAID types...  I'm being told that
by doing so you maximize your I/O capacity.

 I have developed an SP which looks for some text in diferent columns
stored in different tables. I use some of the full-text search functionality.
The key point is that the first time I execute the SP, it lasts for about 30
seconds. But when I execute it again (a few ...

i'm trying to use the Performance monitor to load data directly into a SQL
server Database (Win 2003 server, and SQL Server 2000 Standard)
But the performance monitor log cannot start, after defining the ODBC
datasource, etc.