The only issue you _might_ run into is datetime format differences...the brits do things all bass ackwards. That can be resolved by using SET DATEFORMAT, if needed..but it might not...

Twinsoft SME (10/8/2010)

---

In my experience if you don't have seperate spindles for each datafile it may be pointless to have a 1 to 1 ratio for cores and datafiles. I...

Ignore the memory shown in task manager for the SQL server process. It's not accurate.

Index scans just mean the index was used with no criteria, or the criteria was broad enough that a scan was a better operation. If there was a better index...

Every company I've been at has an upgrade license where we were licensed for SQL Server, period..regardless of version. We could upgrade from 2005 to 2008R2 at no extra cost.

Have...

Well..there's a few things going on here. They're correct on a few points...and incorrect on quite a few.

First and foremost, if they decided against taking txn log backups, then Simple...

Mine modified to Update instead:

DECLARE @data TABLE (

A varchar(50),

B varchar(50),

C varchar(50)

)

INSERT INTO @data

SELECT 'CUTS833','S/S Pocket Tee Red Text Royal Fish White','Edge' UNION ALL

SELECT 'CUTS833_S','S/S Pocket Tee Red Text Royal Fish...

Can you post DDL/sample data of the Event Notice table?

Something like this?

DECLARE @data TABLE (

A varchar(50),

B varchar(50),

C varchar(50)

)

INSERT INTO @data

SELECT 'CUTS833','S/S Pocket Tee Red Text Royal Fish White','Edge' UNION ALL

SELECT 'CUTS833_S','S/S Pocket Tee Red Text Royal Fish White','Edge' UNION...

Are all of your column a values 7 characters, plus _, plus size?

You have a file with many tables and non-uniform delimiters and no target schema generated yet?

There is no graceful way to handle that.

Can you please clarify a bit and give sample data with 1 or 2 rows of expected output? You left out a column letter, interchanging LG/Large..we would need some better...

You cannot ever remove the primary log or data file from a database.

Your best bet is to remove the secondary log file, and then move the primary to the correct...

Check the SQL Server log. This sounds like an issue with encryption.

AndrewSQLDBA (10/7/2010)

---

That tell me the next time the job will be fired off, it does not tell me the frequency. Such as "Every 15 Minutes"

Is this done by a calculation?

Andrew...