Starting a new gig.  Database has one humongous table, 35m rows taking
240gb, which is about 2/3 of the total database.  Up until now it's
been just in the primary filegroup, among other things we're going to
put it in its own.

Just wondering if there is anyway to show the running instances of SQL and
their current memory usage? Also looking for a website with good information
on fine tuning SQL 2005.
Thanks in advance

On SQL 2005 in a slow running query, in the actual execution plan is
using a non clustered index where the estimate is only 1/10th of the
actual number of rows.
How can this be corrected? As I suspect this is causing it to use a

I use SQL Express 2005  occasionally to do some work from home.So most
of the times I don't need SQL Exxpress or SQL Server Browser. I see in
the settings where I can change them from automatic startup to manual
startup.. But if I change to Manual, how do I start these? Or will

I have SAN with RAID 10 (4 drives) (2 LUNS , 2 disks on each) showing 560
logical space. I have read 2 things:
1. put MDF and LDF on different partitions - proabably impossible to answer
this but should i create 2 equal sized partitions for each ?

 I'm still a relative newbie to SQL Server/Oracle and do not have
access to a dba. I have tuned a few stored procedures using the
techniques in Dan Tows book "SQL Tuning" and "stuff I've read" (i.e.
no real training). Puting

I am experiencing a strange problem with SQL Server 2K.
Every so often our website application will lock up because it is waiting
for SQL server.
We run SQL2K on a dedicated server. The server has 3 RAID1 drives (total of

How can I change current schema of a transaction? Eplicitly prefixing schema
name to every object is my only solution?
Regards.

I just created a SQL Agent job which shrinks the log file of a SQL database.
But, I would like to run it when the log file reaches to a certain size (eg.
2 GB).
How can I create such a "file size checker" script which can trigger this

Basically I need an instead of update trigger to manage sequence numbers.
When a user updates data with "sequence" or UPDATE(Sequence) is true, then I
want to run some updates to update the sequencenumbers before the actual
update occurs.

I'm using remote desktop from a VISTA PC to connect to a Windows 2003 server
as the domain administrator.  Using Studio Management I'm connecting to a
local instance of SQL Server.
I can login to that instance without error.  But if I try looking at the

I'm a newbie to SQL. Please bear with me.
With the following example, the postal code will change to 98000 for city
Bothell.
So, what if you need to change the postalcode for all the entries in the

I have a dev server running sql2005 32 bit production is running sql2005 64
bit
Can I or will I run into a problem moving or restoring database and ssis
package to the Production server ?

In SQL2005 using the Maintenance Plan wizard will give a filetype of bak for
the full backup and the differential backup and trn for the log backup. Can
I make my own type for a differential as I want to distinguish the
differentials from the full backups if they go to the same ...

Hi can anyone tell me why...
1) Seemingly at random, when I open SQL Express 2008 Management Studio, I
get the following error (sometimes it is solved by stopping/starting the SQL
Express Service but sometimes it isn't and appears to resolve itself if I try