Viewing 15 posts - 1,426 through 1,440 (of 9,643 total)
Sounds like parameter sniffing and in this case it might be what Grant Fritchey calls bad parameter sniffing.
In the plan with the parameters right-click on the Update operator and select...
May 14, 2013 at 12:49 pm
What is the language on the SQL Server?
What is the locale on the report server and on your computer?
I've never seen this, but it does sound like the query isn't...
May 14, 2013 at 12:23 pm
SpiderDK,
Your issue really should be a separate thread as it doesn't really have to do with Trace Templates. Having said that, you need to find a way to "normalize"...
May 14, 2013 at 7:30 am
Grant Fritchey (4/26/2013)
jasona.work (4/26/2013)
As for smuggling back Canucks, do we want the hockey players...
April 26, 2013 at 10:56 am
GilaMonster (4/25/2013)
Really? http://www.sqlservercentral.com/Forums/FindPost1446662.aspxI get called out for not answering, I get called out for answering. What the...??
That was certainly an interesting read. Not sure where the "chill pill" comment...
April 25, 2013 at 12:47 pm
This is a common problem when numeric data is stored as character and durai has posted one solution. Often in these types of applications the application will prepend 0's...
April 25, 2013 at 11:55 am
Jeff Moden (4/24/2013)
Jack Corbett (4/24/2013)
You could also be thinking about the SOUNDEX function.
Agreed but that's a terrible function. It stops scanning at the first non-alpha character to...
April 24, 2013 at 4:24 pm
apat (4/24/2013)
Infrastructure team is looking at the hardware configuration to find any possible issues there. While backup is running I see BACKUPIO and BACKUPBUFFER wait types.
Those both point to the...
April 24, 2013 at 12:16 pm
You could also be thinking about the SOUNDEX function.
April 24, 2013 at 11:41 am
If I remember correctly, cost is the amount of time it took for an operation to run on the specific computer when optimizer costing code was created. It doesn't...
April 24, 2013 at 11:38 am
shrsan (4/24/2013)
sorry i used this "\t"
Are you sure it is a horizontal tab ("\t")? Sounds like it might be another white space character. I'd through in a...
April 24, 2013 at 11:34 am
apat (4/24/2013)
April 24, 2013 at 11:20 am
Okay. I don't even remember the last time I was on here. I'm not even going to try to catch up. Just based on the mentions of...
April 24, 2013 at 9:57 am
I'd start with something like this which is the most common way to get a previous value:
WITH ctePFE
...
April 24, 2013 at 7:21 am
The recommended method for returning a single value from a stored procedure is to use an output parameter. Which I'm sure is what the link provided in the previous...
April 24, 2013 at 7:08 am
Viewing 15 posts - 1,426 through 1,440 (of 9,643 total)