Going back a couple of employers, I have to agree. We purchased multiple licenses of SQL Server 2005 and later SQL Server 2008 that we installed on multiple servers....

Basically been in IT my entire career. There was a stint after I got out of the Air Force (was a computer operator) where I worked a a 7-11...

You've shown us the function itself but not how you are using it. Give us the whole picture, not just little pieces of it.

Jeff Moden (10/31/2011)

---

isuckatsql (10/31/2011)

---

I have a simple SSIS package that reads a SQL DB input file, runs thru a script and does some parsing using regex, then updates a different...

I have to agree with Craig. Also, SSIS isn't always the best tool for the job, as you may have discovered when transforming data between tables in the same...

Question, are level 1 values unique to level 1, and are level 2 values unique to level 2, etc?

sdownen05 (10/31/2011)

---

Lynn,

Thank you very much for the code, and also for correcting what I had sent. This works fine except for one thing; I get this message when I run...

JamesMorrison (10/31/2011)

---

EdVassie (10/31/2011)

---

Is this an experience seen elsewhere? Is DBA work still seen as a vibrant are to move in to, or are we seeing the DBA role becoming...

Sorry to say but you haven't provided us with enough information to really help you.

We the DDL for the tables, sample data for the tables (enough to represent the problem...

You need PATINDEX, try this:

IF OBJECT_ID('TempDB..#JobName','U') IS NOT NULL

DROP TABLE #JobName;

GO

--===== Create the test table

CREATE TABLE #JobName(

JobName NVARCHAR(100)

);

--===== Insert the test data into the test table

INSERT...

Check the SSIS package(s). IIRC they can actually be setup to not fire triggers on insert.

David Moutray (10/28/2011)

---

Index rebuilds in full recovery are fully logged. Because of this, the index may be taking a long time because of transaction log issues. It might be running...

Previous previous employer, network services handled the servers and installation of the OS and OS patches. I installed SQL Server and applied the service packs when released.

Worked well.

Could you post the DDL for your table(s), sample data for the table(s), and your expected results based on the sample data?

For help in doing this, please read the first...

Sapen (10/26/2011)

---

Also I forgot to mention that the DETA recommended to create a lot of statistics along with the indexes. Right now I am about to rebuild the indexes. Is...