Using 64 Bit server running 64 bit SQL 2005 sp2...
I saw a comment that Statistics can exist that aren't associated with an
index.  (See
http://decipherinfosys.wordpress.com/2008/03/19/understanding-the-difference-bet
ween-indexes-and-statistics/ )

using sql server 2000 with classic asp
have a table with a field "series count"
every invoice made will have an incrementing series count
so when everytime an invoice is made:

I Have Two sites , Site1 and Site2
site one has two servers A and B and DB Mirroring is happening in two.
now i want to build Disaster Recovery plan on Site 2 for Site 1 that has
servers C and D for Site 1 which will work same like A and B servers ,

H
I am using SQLMail in my SQL Servers for the alert notifications. Today it has failed due to some reasons. I was trying to restart the SQLServerAgent , I got the error "[311] Maildispatcher Thread (ID 1444) still running"
It may be as the SQL Mail is conflicting with ...

I have SQL 2005 Enterprise. I changed the password to the sa account. I know
I am not using my sa account in any of my applications. And all the service
accounts are using a domain user account. Have other SQL 2005 and not getting
the error message. Not causing any known problems ...

I have these tables:
1 bookings
2 bookingsFlightLists
3 flightLists

I am using SQL Server 2005 and I would like to update my tables as follows.
Table1  (it has three fields I'm working with)
CustomerID
SiteID

I have a Dell 2950 running Windows 2003 Enterprise Edition with a
MD1000 attached to it with RAID10.  SQL version is Standard.  The
system has 8Gb of RAM and I am wondering how to utilize memory in the
most efficient manner.

I installed SP2 on my SQL server, but when I run the [select @@version] its
still showing SP1, but when I go under [Add/Remove Programs] it has SP2 for
SQL 2005 listed. What would cause the SQL server not to show SP2 when I run
the [select @@version] query?

Hi
I have inherited a server, which looks like it has had replication set up in
the past.
One of the databases in particular is causing a problem which the our

I am designing a table for a financial application and I have a situation
where there are more than 100 different attributes of an entity to be
persisted in the database. All these attributes depend directly and
completely on the entity's identity ( which is the primary key of ...

Hi
My SQL server crushed and I found in event view the following information.
SQL Server has encountered 3 occurrence(s) of cachestore flush for the 'SQL
Plans' cachestore (part of plan cache) due to some database maintenance or

Hello Experts,
for our Six sigma report, we require to know the number of trasaction per
week on our database, we have 100s of tables,
please help me to get the trasation count of a week ie. mon to sun.

This is the first time I'm confronted with this type of problem,
probably since I was not using larger databases before, but now I'm
stuck and hoping someone can point me in the right direction.
I have a table in a database on my SQL Server 2005 Standard edition

We will be migrating several SQL servers (non-clustered) to a new
Active Directory domain in a seperate forest.  We plan on using the
ADMT to migrate the computer and user accounts.  Other than adjusting
the startup accounts on the SQL services, is there anything else I