Two (almost) identical SQL Server databases (DB1 backed up and
restored to DB2 yesterday).  DB2.dbo.GetSchPaymentsTD took 1.5 seconds
(!) to execute DB1.dbo.GetSchPaymentsTD took less than a millisecond
with identical code and data.

Hello, hope u can help or point me in the right direction
I have 2 Services on our production System
1 Service is Vb6 (not the problem)
2 nd service is on another maching  c# (not the problem)

I have the following query, but the issue is that there are multiple
results of IP Address with different labels in computer name. I only
want the first result, but distinct doesn't work.
select distinct computername as [Computer Name],

Hey guys,
I am stucking trying to create a SQL update statement that will do the
following:
Assign a discharge date =  three days after the admit date.

I have a table with something like this:
ID.............Job..............$$$
1...............A..................5
1...............A..................5

MSDE2000 installed on 2003 Server.
With Windows Firewall turned ON, users in the same workgroup as the 2003
Server can connect to the SQL Database.  Users on a different Workgroups
cannot connect to the SQL Database using either IP or ComputerName.

There are some small examples in the new BOL, but not what I look for.
Has anyone some good links with xevents showing wait stats?
Best regards
Bjorn

I am connecting remotely using SSMSE to a SSE on a W2003 server box using
WINDOWS authentication (NOT SQL Authentication)
This all works fine except I would like to know the "best" WINDOWS user
group for this user to be a member of ....

I am trying to setup a new maintenance plan that does nothing more than a
scheduled backup of a database. I am able to backup this database manually
from database\tasks\backup. When I execute the maintenance plan it fails
with the following error. I have looked in the log file ...

I have a job which being scheduled at the night time. after now a day im
facing a problem where my job fails. server is not restarted neither job is
being stopped. the error is as follows:
Executed as user: NT AUTHORITY\SYSTEM. Login failed for user 'NT

I installed SQL 2005 on a domain controller and I am getting the following
error:
There are multiple accounts with name SQLSvc/Domain Name:1433 of type
DS_SERVICE_PRINCIPAL_NAME

I've got a new client machine with Windows XP SP3.  I'm trying to install
Proclarity Desktop Pro v. 6.3.129.200.  
The install starts and then it stops with a message "The following items
were not found and are required to install Proclarity Desktop Pro 6.3:"

I have the need to get the last child of each parent.
Note:    eDate if what points me to the Last child not the c1_id
Parent ( pk1_id , etc..)
Child ( c1_id, pk1.id, eDate, type_id)

Using MS Query, I like to query an Informix database and get the result of
multiple rows on a single line. I would like to end up with a specific
colomn showing the result on a signle line which include several rows like
this

My company want to use database for ERP, any website to discuss DBMS
advantage and disadvantage ? or someone post to here for references ?
Thanks