SQLBits (http://sqlbits.com/) is another good conference to attend, though it only runs once a year.

I think its fair to say that SSIS, SSRS (in one form or another eg, Powerview), and SSAS (Tabular/Olap) will be around for the next 2-3 revisions.

SSAS is partuicularly...

ssms-man (10/8/2012)

---

Jason-299789 (9/25/2012)

---

SSMSBoost looks interesting, though looking at the list of features you dont seem to get what phil is looking for, and seems very similar to SSMSTools, all be...

If it is a paramater sniffing option and you are using SQL2008 you can use the Query Hint OPTION(RECOMPILE) on the offending SELECT statement, which should solve the issue and...

While DTS 2000 is technically supported in SQL2008 its only available on the x86 (32bit) version.

See

http://msdn.microsoft.com/en-us/library/bb500440(v=sql.105).aspx

Especially

There is no 64-bit design-time or run-time support for DTS packages. On a...

That is is a flawed way to approach the solution, as...

Lokesh Vij (10/5/2012)

---

Here is the modified version with totalcount values:

SELECT ERRORCODE, ERRORDESC,

Terminal_1 = MAX(CASE WHEN TERMINALID = 'Terminal_1' THEN TOTALCOUNT ELSE 0 END),

Terminal_2 = MAX(CASE WHEN TERMINALID = 'Terminal_2'...

You need to export the results to a file (CSV, Excel) in SSIS then add that file as an attachment in the email task.

Since the release of SQL 2008 there are less problems with paramater sniffing than you had on previous versions, as you can use the OPTION(RECOMPILE) on an SQL statement which...

I've dont exactly this on a previous projcet, except that the source was a differnt database.

The only way I could get round it was to execute a child package...

It seems strange that the FK on the tblgas has the same name as the Average consumption table, is this really the join? but it could be true but as...

Basically the SQLAgent account that you're using has no rights on other server(s).

So Adding the SQL agent account to the other server and granting it access rights to the server...

MysteryJimbo (10/3/2012)

---

Data is not restricted on a permission basis. Either you can read the data or you cannot and you get a select error (unless the application handles the...

Thanks for the response Gaz, and the advice, at the moment I'm just doing a proof of concept and getting used to how to configure the resource governor, ready for...

as an example this is how you would put a variable in to a merge

MERGE TargetTable as Target

Using SourceTable as Source

On Source.Key=Target.Key

When Matched

And Target.SomeColumn!=Source.SomeColumn

Then Update Set

Target.SomeColumn2=Source.SomeColumn2

,Target.Somecolumn3=@Variable

WHEN NOT MATCHED BY...