Microsoft SQL Server 2005 - 9.00.3054.00 (X64)
(Build 3790: Service Pack 2)
Last Friday we had a situation where the DNS system inside
our Active Directory server went weird.  I know this isn't

I'm working on a Windows 2000 machine which hosts a SQL 2005 Express
Database.
This database is backed up using the following method -
http://www.sqldbatips.com/showarticle.asp?ID=27

I have a system which is running SQL queries almost constantly against
a database. One problem I am having is that sometimes queries become
slow for no reason. The query looks like this,
select * from DataStore where dataStoreName = 'name' and rowid in

Simple questio - how to add rows to table in Microsoft SQL 2008
Server.
I don't mean by executing query (INSERT INTO...), but by clicking on
table or something - not by writing query manual.

Could you please advise whether there are documents describing impact of
MS SQL server 2005 database size on its performance? I have essentially
two things in mind when writing the "database size":
1.) number of records stored within the database (e.g. one customer's

1)
Here is the error that I got after the SQLBulkImport imported 160000 records.
Error: Received an invalid column length from the bcp client for colid 2.
What could be the reason for that error?

We are using SQL Server 2005. The SP in question is a fairly simple
select statement. When the developers run their unit tests it is
timing out (15 second timeout is set from their end). When I run the
SP in a query window using the exact same parameters it takes less