Viewing 15 posts - 1 through 15 (of 1,161 total)
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...
September 10, 2014 at 11:11 pm
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...
September 10, 2014 at 8:13 am
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...
September 8, 2014 at 5:55 am
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.
September 5, 2014 at 10:14 am
Luis Cazares (9/3/2014)
September 3, 2014 at 8:23 am
Grant Fritchey (9/3/2014)
September 3, 2014 at 7:44 am
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...
September 3, 2014 at 5:47 am
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...
August 29, 2014 at 8:41 am
You don't need to be using a Stored Proc to pass properly typed parameters.
Follow the example here:
Basically, refer to the parameter using normal @VariableName syntax in your CommandText, then add...
August 29, 2014 at 7:37 am
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...
August 29, 2014 at 5:30 am
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...
August 26, 2014 at 6:45 am
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...
August 18, 2014 at 6:22 am
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) ...
August 18, 2014 at 5:59 am
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:
August 8, 2014 at 7:59 am
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...
August 1, 2014 at 7:10 am