Yes, I removed the Primary Key on the audit table as well.

Thanks everyone for the help.

THanks a million. I made the JOB_POSTING_NUM an identity column in the audit table and removed that column from the trigger. I overlooked that 'little' detail. Just...

same as the real table...

CREATE TABLE [dbo].[JOB_POSTING_AUDIT](

[JOB_POSTING_NUM] [int] NOT NULL,

[SITE_NUM] [int] NULL,

[JOB_CAT_COD] [varchar](7) NOT NULL,

[DEFAULT_TXT_IND] [bit] NOT NULL,

[ADDRESS1_TXT] [varchar](100) NULL,

[ADDRESS2_TXT] [varchar](100) NULL,

[CITY_NAM] [varchar](50) NULL,

[ST_PROV_COD] [char](2) NULL,

[POSTAL_COD] [varchar](10) NOT NULL,

[START_DAT] [date]...

I agree. It goes to show you that your hardware is not the bottleneck. Sometimes it is just simply the I/O can only go as fast as it...

Have someone give you examples of what SQL will run against the dbs... or start a Profiler session and have app folks run what runs against the db. Then...

Great article. It drives me crazy that Microsoft, out of the box, has such small sizing and grow by 10% for model and TEMPDB. The first thing I...

FYI: Some tables will not replicate if you don't have a Primary key on them.

You can view Task Manager for CPU usage and there are some good monitoring tools to graph that over time to see if you are maxing the box at high...

First of all what do you mean, capacity for existing?, capacity planning for new? Also, what version of Windows, what version of SQL Server?

I agree. I always stop SQL Server and make file copies of master, model, msdb after an install and prior and after a Service pack too. As a...

That is your back end SAN snapshot. We have it here as well. Talk with your storage Admin

What do you want to start it in single user mode? Typically this is reserved for restoring master or if there are major problems with SQL Server you put...

Question: How big is it getting? Remember, that all sorting of data goes on there and it can get quite large. If you rebuild indexes and say...

Great, thanks. I just implemented this on one of my SQL Servers and will do some more as well.

calvo (3/27/2013)

---

Base stealing is fun, indeed. Should happen quite a bit more with the removal of the fake to third throw to first pick-off move. Not so sure I agree...