David,

I agree with you that the clustered index with it's 4 columns is a bad thing.  Unfortunately, I have been advised to be VERY careful should I want to change...

Lots of good info here...

http://www.sql-server-performance.com/database_design.asp

I use this site a lot as well as SQL Server Central.  Enjoy!!

--Lori

I use Idera's SQL Diagnostic Manager.  It monitors performance, will notify you when performance dips and gathers statistics together nicely.  The nicest thing is that it can read the trasaction...

I have this script in my archives...

CREATE FUNCTION LPAD(

@Char1  VARCHAR(8000),

@n  INT,

@Char2  VARCHAR(255))

RETURNS VARCHAR(8000)

AS

BEGIN

 IF DATALENGTH(@Char1) > @n

 BEGIN

  IF SIGN(@n) = -1

       RETURN SUBSTRING(@Char1, 1, 0)

   RETURN SUBSTRING(@Char1, 1, @n)

 END

 RETURN REPLICATE(@Char2,...

You should set off your Profiler and then disconnect instead of logging off in terminal services.  When you log off your session closes and anything you are doing stops too.  Just...

With 400 connections, have you checked to see what your maximum worker threads is set at?  I think out of the box it is set at 255.  You might want to...

So far we are going to start with 1 data mart that will show sales and needs to be able to be queried by salesmen and even possibly customers.  We...

Wow!!  What good advice!!  We do have SQL Server 2000 Enterprise Edition on the server where we are intending to house the data for the DW.  We do know that...

My solution so far has been to take Steve's approach.  I made a job that queries a table from the database and logs the time.  I set it up to...

There is another way.  You can query AD and put everything into a table.  Here is how I have written an LDAP query before...

EXEC sp_addlinkedserver

 'ADSI',

 'Active Directory Services 2.5',...

This is all really good info.  I have never had an application or database with barcodes and did not realize that this should be a font.  But, I guess I...

Thanks Jim!!  I thought that I had it down but wanted to make sure.  I think I will go the business owner and tell him that this is "bad juju". ...

It is because this user does not exist in this server. First of all the user must have a login that exists. You can create one if you...

Thanks a bunch!  That is what I thought.  A full backup is taken every night with tlogs done every hour from 5am - 8 pm.  The database is about 30GB and...