you basically declare the table variable like this:

declare @PermMask table ( RoleName varchar(20), mask int)

then your code would be like:

...

Where is the C# code running? is it an external application or some CLR code from inside the server? You were not clear on that and where it is coming...

1000 per sec is not that high for some of my servers. That measurement all by itself has little meaning.

The name 'covered index' means the index covers the select list of the query without needing to even hit the table.

A pure covered index means all covered columns exist in...

It may not be entirely doable with TSQL. I would probably opt for manipulating a word document via CLR in C# via the system.xml namespace. It gives you...

I second Gail's advice, go for 130GB allocation to SQL server and see how it works out.

If it were me, I would NOT set the lock pages in memory and I'd set a max memory value that would leave enough memory for the other Apps to...

I would say if it is a dedicated machine and you have pre-configured the min and max memory settings for SQL server it would be fine. On the other hand,...

I'd consider using CLR for this sort of thing, but you can run a batch file via SQL Agent as a scheduled job.

Agreed, though I wonder how many DBAs actually have the authority to set the rules involving database security policies or even set standards for developers and insist that they be...

We use scanning software against our sites and we have also had third parties run scans and other penetration attempts. From this we have made a number of improvements to...

What I had originally suggested was to add the code I posted to your job step, no need to modify an existing procedure.

Glad you got if worked out though.:-):-)

actually you can eliminate the variable and just do this:

if DATEPART(dw,convert(datetime,convert(char(2),getdate(),101) + '/01/' + convert(char(4),datepart(YEAR,getdate())))) between 2 and 6

execute sp_yourProc

(sheesh my keyboard is terrible on this...

SQL Agent front end has no way to do this that I know of. But all you need to do is add these lines of TSQL to your Job...

What I do is add a line in the job proc (assume stored proc) that check to see if the current day is the first Weekday of the month. If...