DM definitely has a trace that runs on a...

You aren't going to be able to use a standard SSIS Flat File Source for this, you are going to have to do scripting to read the file row-by-row. ...

I recommend you read the series of posts on XQuery by Jason Strate found here, http://www.jasonstrate.com/tag/xquery/. He does a better job explaining it than I can, but, briefly, .value...

The first one is dynamic sql and where the parameters have a default value of empty string ('') you need to change it to '''' (four single quotes) because the...

Evil Kraig F (11/18/2014)

---

*stares at 3 pages of spammers*

Steve... can you convince the powers that be to put up a 'board of shame' or something on these spammers? Stick...

There are several tools out there from RedGate, Idera, Dell (formerly Quest), and I'm sure others. The third-party tools usually have more compression options and also often include encryption...

You can also look in sys.dm_exec_sessions and the transaction_isolation_level column to find out if the devs know what they are doing. Here's the mapping from BOL:

0 = Unspecified

1 =...

In order to "upwards" cascade parameters you'd have to load all the values for every parameter into the report to start and then do the filtering on the reporting server...

A variable can only hold one result so all this:

DECLARE @N VARCHAR(MAX)

SELECT @N = [Name] FROM [dbo].[database_tags]

Is returning is the Name from the first row it...

I know it can be done because I believe both PragmaticWorks BIExpress and Myst by Varigence allow you to inject code into existing SSIS packages. I'd recommend looking into...

I don't think that there's a number that anyone can give you. You have to be wary about adding suggested indexes. I like to at least do the...

If you are an employee you probably have something in your employment agreement that states that the company owns the code you write on their time and/or their equipment. ...

Is the static data for each of the 6 sections the same regardless of the package?

It sounds like you just need to re-work your grouping so that an entire work order is together. I'm assuming that you are using a tablix/table so you just...

Typically you want to give the better hardware to the database server. Web servers can be scaled out while database servers have to scale up.