Does the optimizer take into account server load and available memory - and
any other resources it needs?
We have a database moved to SQL Server 2005, and like most people it
suddenly runs slow.  For one query in particular the logical I/O incresed by

We are using 2005 64bit, the server is very decent. We have a project which
will use a table to store quite large numbers of records, I know rows per
table depends on the limitation of storage, however, I like to know what's
the rocemmened rows per table which won't affect ...

I use SQL 2005 as the back end for an Access application.  I have set up an
image field in SQL which translates to an OLE Object field in Access
(exactely what I want).  I have placed an unbound object control on a form
that uses the OLE object field from the table.  When I ...

I have set up a job on SQL server and users want to be able to run it as
needed.  Is there a way to allow them to run the job without installing SQL
client on their machines.

I want to transfer dat from one table to another and put two fields into one
during this transfer - can this be done in a query
table 1
house no

Moved SQL to new hardware with same name and IP. All went well except SQL
Enterprise Manager "About" reflects RTM not SP4 level. (SQL Instance does
reflect SP4 level.) Did not notice discrepancy until after we brought up and
started using the front-end apps (e.g. WSS 3.0 and 3rd ...

I have a sales order detail table containing a column of decimal (18,2). If
I post a value of 100.00, the value is being rounded to 100. How can I ensure
that the 00 after the decimal point is stored in the table - it would save a
whole lot of formatting within the client ...

After having avoided the topic for some time (previous attempts to grasp the
concepts resulted in near brain meltdown!), I have decided now is the time
to completely come to terms with indexing and query optimisation.
After a couple of posts here and a fair amount of reading I ...

I'm creating a table with activities. These activities are defined by
a name, a start datetime and a interval. The two first types are
obvious. But I'm unsure abut the interval type.
Initially I used a int column holding the number of seconds a given

I've read about it but I don't get it.
How and why would you do this.
Is a view (at run/select time) not just the same as a written SQL statement?
Doesn't it just query a table and the table have index(es)?

I have a stored procedure which is having multiple cursors. These cursors are
affecting the performance of SP.
With SQL Server 2005 we can write the SP in C#. If I replace those cursors
with for/while loop of C# code then will there be any performance benefit

If i execute a query that take a long time how can i tell which part of the
query is causing the problem ?
Is there anyway to step a query ?
Profiler just shows execution start & stop.

Export to Excel
I would like to run a query in SQL Server 2005 and export the result set to
excel automated, how can I do this?

I have a SQL Server set up as Windows Authentication. I am trying to
use another PC (client) to connect to the server, but kept getting the
following message:
A connection could not be established to XXX (the server name)

I'm hoping someone can really give me a hand here. My dumb SAN storage guy
will not assign me proper storage for a low end SQL server unless I give him
some IOPS, bandwith to calculate disk size and for both numbers he wants to
know the average and expected peak, plus a ...