I'm assuming it's the conversion from a binary(8) to varchar that's causing the problem. If you output cast(eqs.query_hash as varchar(255) ) in the select, does it look different?

You might want...

I think there's a step missing from that tutorial. You need to go into the Variable Mapping tab in the ForEach loop container and map the connection string variable to...

Fundamentally, I don't think that AlwaysOn in itself prevents MSDTC from working. The problem is when an application attempts to invoke MSDTC from a connection using an AlwaysOn Availability Group...

It's a very odd database that has some quirks and few of the properties that you'd find in most relational databases, but it does have a reasonable enough SQL-like syntax.

My...

Luis Cazares (9/3/2014)

---

If your function is a UDF, then it's bad (I'm not sure if deterministic UDFs will be bad as well). I've seen large improvements when changing UDFs on...

Grant Fritchey (9/3/2014)

---

Pretty much that whole WHERE clause is an issue. Functions on columns or functions to determine values within a WHERE clause, JOIN criteria or a HAVING clause will...

The UDF isn't the problem here, the MONTH(CDate) is most likely to impact performance as it's non-SARGable.

It should be easily possible to generate a from and to date rather...

The difference between the two would be trivial for any meaningful dataset as they are both SARGable.

As I mentioned in my first post, this is a special case...

You don't need to be using a Stored Proc to pass properly typed parameters.

Follow the example here:

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.parameters(v=vs.110).aspx

Basically, refer to the parameter using normal @VariableName syntax in your CommandText, then add...

The example posted is fine. Virtually any method where you're performing the conversion against the parameter will be trivial to the overall runtime as they only have to be evaluated...

The display format of dates is dictated by the client, not the server. A date is a type that has no specific display format.

SSMS, for example, is a client of...

Hmm, seems you can't easily run explorer as admin in Server 2012/Win8 (which seems like an oversight to me!). You could definitely validate the assumption from a elevated/non-elevated cmd prompt...

Are you sure this isn't just a UAC problem, rather than NTFS permissions? Any directory off the root of a system drive will require elevated permissions (Run as Administrator) ...

What I've done in the past is manipulate the data into tabular format in Excel using a Pivot Table and then it's just a straight import:

http://datapigtechnologies.com/blog/index.php/transposing-a-dataset-with-a-pivottable/

Unless you're utilising specific data types and features of SQL 2012, Oracle SQL Developer can definitely do a reasonable job of scripting objects and data to give a starting point...