SQL Server, SQL Server Query Analyzer setup

1. SQL Server Query Analyzer faster than ADO.Net SQL Data Provider - Microsoft .NET Framework

2. How to access SQL Server 2005 with Query Analyzer (SQL 2000)

I'm not able to run queries on a MS SQL Server 2005 using the Query Analyzer 
from an XP Pro machine running MS SQL 2000.  I'm able to connect to the SQL 
2005 server and display all objects in the Object Browser but can't run a 
simple query.  Any ideas?

By the way, I'm connecting with a new SQL account I created in SQL 2005 with 
full rights.

3. SQL Query Analyzer Connectivity to a remote SQL Server

4. CORRECTIO: SQL Query Analyzer TO SQL Server from NON-Domain Comput

It is from a Window's VISTA computer

"MSUTech" wrote:

> Hello,
> 
> I am trying to connect from SQL Query Analyzer (on a WinXP machine that is 
> NOT within our ActiveDirectory DOMAIN) to a SQL Server SERVER within the 
> Domain.
> 
> What is the 'best' way to do this - can I just reference the IP of the 
> server and then the correct port, from WITHIN Query Analyzer, or do I need to 
> do something else?
> 
> thanks

5. SQL Query Analyzer TO SQL Server from NON-Domain Computer

6. SQL Server Query Analyzer faster than ADO.Net SQL Data Provider

Hi,

I wrote a stored procdure in SQL Server which calculates some metrics.
This procedure always returns only one row with 11 columns of integer
values.

I ran it in SQL Server Query Analyzer thru a remote machine and it executes
the procedure in 5 to 6 seconds.
I wrote some ADO.Net SqlDataReader code and it takes 25 seconds to get the
data back from the same remote machine.
I tried SQLDataAdapter also and it takes 25 seconds.

I logged the time before the database call in the code and immediately after
the Command.ExecuteNonQuery() method.
I clearly see that it takes 25 seconds.

I also tried using Data Access Application block v2.0 from the microsoft
site. Even it takes 25 seconds.

I don't understand why Query Analyzer is so much faster than ADO.Net Sql
Data provider?
Can anyone explain this?

Thank You in advance
Vidya

7. Command to export data from sql server to text file in sql query analyzer - SQL Server

8. Access 2000 Query very slow compared to SQL Query Analyzer

I have the following Access 2000 query that runs so slow I can't even wait
until finishes.  (over 5 minutes so far).  When I run the code in SQL Query
Analyzer it doesn't take but 1 second.  I know there are differences between
what Access can handle and SQL Server, but there has to be something I can
do to make the Access query run faster.  Any suggestions?

WB

Access query
SELECT a1.Id, a1.StoreId, a1.StylistId, a1.CustomerId, a1.AptDate,
a1.CreatedDate, a1.AptStatusId
FROM tblAppointment AS a1
WHERE (((a1.AptDate) Between CLng(CDate([Enter Start Date])) And
CLng(CDate([Enter End Date]))) AND ((a1.AptStatusId)=3) AND ((Exists (SELECT
*
                            FROM tblAppointment a2
                            WHERE a2.AptDate > a1.AptDate AND
                                         a2.CustomerId = a1.CustomerId AND
                                         a2.AptStatusId = 1 AND
                                         a2.CreatedDate < cdate(a1.Aptdate +
1)))<>False));


SQL Query
DECLARE @startDate AS DATETIME
DECLARE @endDate AS DATETIME

SET @startDate = '01/01/2010'
SET @endDate = '01/15/2010'

SELECT a1.Id, a1.StoreId, a1.StylistId, a1.CustomerId, a1.AptDate,
cast(a1.AptDate - 2 AS DATETIME) AS 'ApptDATE', a1.CreatedDate,
a1.AptStatusId
FROM tblAppointment AS a1
WHERE a1.AptDate BETWEEN CAST(CAST(CONVERT(char(8), @startDate, 112) AS
DATETIME) AS NUMERIC) + 2 AND
                         CAST(CAST(CONVERT(char(8), @endDate, 112) AS
DATETIME) AS NUMERIC) + 2 AND
      a1.AptStatusId = 3 AND
      EXISTS (SELECT *
              FROM tblAppointment a2
              WHERE a2.AptDate > a1.AptDate AND
                    a2.CustomerId = a1.CustomerId AND
                    a2.AptStatusId = 1 AND
                    a2.CreatedDate < CAST((a1.AptDate - 1) AS DATETIME))