This might be more efficient for creating the columns also you would need to put the ColNameXX into the square brackets like [ColName1] etc.

This will generate upto 256 columns in...

Technically there is a way to do this, but it would mean using a Script task which creats the connection, executes the relevant stored proc, and manipulates the data into...

If its only called once a day then its not too bad, so probably an Amber for refactoring, it it was being run more regulararly then you may want to...

I have found that when naming default constraints they are best defined as something line DF_<schema>_<table>_<column>

This avoids name collisons in the same database.

Abu Dina (6/12/2013)

---

with SCC_CTE(vend_i, dept, tot_wgt)

as (select 1, 1, 75 union all

select 2, 2, 40 union all

select 3, 4, 50 union all

select 3, 5, 80)

select vend_i, dept from

(select ROW_NUMBER()...

Another couple of things I noticed that you might want to change, the use of @@Identity which isnt thread safe, so you might want to consider switching it to use...

I think there are specific counters in Performance monitor for SSRS, have a look in Performance Monitor for SSRS related counters.

Although reporting Services should be fairly lean in terms of...

Hi,

Can you provide the query you already have and we can then offer guidance on where things may be wrong.

I've been playing around with an 'addin' for VS2008 database projects to do simple coding standards checks eg non Alpha characters in object names, the use of tbl_, t_ prefixes,...

It could be parameter sniffing but SQL server can do some peculiar things when you have number of nested views, such that it doesnt use the optimal plan at the...

The reason the plan for the Archive DB doesnt change is because its read only, where as the 'live' db will have data being added/removed during the day so it...

No problem, I empathise with how you must feel.

I was playing around with the resource guvenour about a year ago, hes my post on what I'd done with a...

As far as im aware the Plans get removed from the Cache when

1) Stats are updated, thus invalidating existing plans.

2) the table is altered

3) Indexes are rebuilt/added/deleted

4) SQL Instance...

If its for an emergancy test environment you might be able to get away with a Developer edition of SQL server.

Or if anyone has been on a MS...

THeres also a very good White paper on the resource governor which can be found here http://msdn.microsoft.com/en-us/library/ee151608(v=sql.100).aspx

If you've read BoL then I would suggest reading this next as it goes...