Paul White (9/3/2009)

---

Just for completeness, this is also valid:

-- Just to simulate some condition or other

declare @v-2 int;

set @v-2 = 2;

-- Dear Lord, why am I using a cursor here?

--...

Let's throw another take on it.

I run my business out of Mass, but use the software and services you provide - which have no physical presence in Mass. In...

If you script out the job, you should be able to see the command that is used to run it.

dtexecui is GUI based and dtexec is cmd line based.

Could you provide us with the code that you are using to create this report?

Odd how the answer I selected was the answer provided as being correct - but I got it wrong.

It goes to the protection of the consumer and their private data. Any person doing business in another state needs to protect the consumer data that resides in that...

sys.dm_os_performance_counters would be a good place to start.

And then it depends on what your needs are as to which counters to study and graph.

I agree with Grant, you don't necessarily need to master TSQL up front. The job will be more difficult without TSQL.

Other than books, you may want to check out...

Good information indeed.

Another one to add to the pile with Cal. Privacy, Sox, and PCI.

IA64 is for the Itanium 64Bit processor class.

X64 is for the Other sets.

From what you listed as installed, you should use the X64 version.

Keep in mind when setting the size, you want to be able to have enough space such that at least 3 months or so will be accomodated without an Autogrow.

If...

Another possible area that caused the extra space was alluded to in the first response by Steve. It is possible that there was a reindex as well.

Options for the...

Hadn't thought of it but....

Mud Farming comes to mind 🙂

Seriously...

Maybe an Engineer

see

Previous Forum Thread

Go ahead and remove the paretheses from your select clause

instead of

select

(inserted.PedNum,

...

inserted.[PedObs],

'2')

select

inserted.PedNum,

...

inserted.[PedObs],

'2'