Viewing 15 posts - 1,426 through 1,440 (of 9,641 total)
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
This error is indicating that there isn't enough memory for the SSIS process to handle the number of rows that are being returned. If the SSIS package is being...
April 24, 2013 at 7:04 am
I can't remember the exact syntax in SSIS but you need to do a replace using the ASCII code for tab which you can find at http://www.asciitable.com/. You can...
April 24, 2013 at 7:02 am
Viewing 15 posts - 1,426 through 1,440 (of 9,641 total)