Since format files specify the data type of the text file you are working with, it's common to always use SQLCHAR as the datatype, and specify a collation if the...

It's hard to tell offhand what exactly your problem is, but I did have a couple of suggestions...

Your Maximum Server Memory for your SQL Server instance probably should not be...

You might want to check out the CONTIG utility available in the File and Disk utlilities section here:

http://technet.microsoft.com/en-us/sysinternals/default.aspx

I've had success defragging specific files, even SQL Server database files...

From what I've seen, the PIVOT can be easier to read, but the CASE gives the same or better performance.

With 20-30 concurrent users, you will start to notice problems with Access and you will probably have to compact and repair nightly to avoid database corruption. A good fit...

You'll also want to make sure that the columns you are trying to make part of the Primary Key are defined as NOT NULL. You can't have NULL columns...

Faster disks will only help query speed in cases where you have a low data buffer cache hit ratio. Part of database tuning is optimizing memory usage so that...

I think you need to change your join. You said you wanted rows from the parent table (employee) that didn't have a record in the child table (order), so...

What I'd suggest, is that your primary key on the parent table looks something like this:

[font="Courier New"]CONSTRAINT PK_ParentTable PRIMARY KEY(PartNumber, YYYYMMDD, SeqNo)[/font]

and that the foregn key on the child table...

I believe the problem is the way the UPDATE statement has a SUM() aggregation with a subquery inside of it with another SUM() aggregation. You'll probably need to rewrite...

Actually what you've considered doing with passing XML to the database stored procedure is a very common practice. You can use the XML capabilities of SQL Server 2005 to...

Maybe I'm not understanding the question, but it seems to me that breaking up the SalesItem field into PartNumber, YYYYMMDD, SeqNo would be the best answer. You can have...

It is available in SQL Server 2008, but not in 2005.

I noticed in the second half of your OR condition, you check:

[font="Courier New"]R.blocking_session_id = 0 AND R.session_id IN ...[/font]

It looks like your query will show the blocked processes, but only...

1. Your choice of recovery mode will depend on if you need point in time recovery of your databases. If you do a restore, will an overnight backup...