Viewing 15 posts - 6,091 through 6,105 (of 7,168 total)
TheSQLGuru (6/15/2011)
1) have you run a profiler trace, looking for recompiles while this thing is running?
I have not traced the process but will give it a go. I have an...
June 15, 2011 at 10:24 am
Or you can look into using Dynamic Cross Tabs:
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url]
Similar to how Cross Tabs outperform PIVOTs, a Dynamic Cross Tab process will...
June 15, 2011 at 10:14 am
GhandiDBA (6/15/2011)
Thank you very much for your help, that syntax was exactly what I needed!Kind regards
You're very welcome 🙂
June 15, 2011 at 10:04 am
michael wang-201906 (6/15/2011)
i found the same issue on MSDN, seems 'a file that sometimes contains an extra CRLF at the end of the file' cause the problem.
The problem is exactly...
June 15, 2011 at 9:42 am
Hi Brandie, I get what you're saying about keeping everything together for manageability and I agree, it's a good practice to keep related pieces of logic that make up what's...
June 15, 2011 at 8:59 am
lfernandesfotos (6/14/2011)
The analysis is interesting, however, can make life difficult for developers that use the database.
It depends on the developers 😀
June 14, 2011 at 10:32 pm
lfernandesfotos (6/14/2011)
The advantage of using a bit instead, for example,...
June 14, 2011 at 10:00 pm
GhandiDBA (6/13/2011)
I was wondering if you are able to build an expression for a constraint that will check two variable values before proceeding, or if you have to do some...
June 14, 2011 at 4:32 pm
What you posted is not technically SQL. It's application code written in the data layer masquerading as SQL.
Reformatted:
SELECT @sql2 = @sql2 + CASE WHEN @alias_rede = 'AMAZON' THEN 'and...
June 14, 2011 at 4:25 pm
sku370870 (6/14/2011)
June 14, 2011 at 4:02 pm
Please see the section "Mapping Integration Services Data Types to Database Data Types":
June 14, 2011 at 3:42 pm
Craig Farrell (6/14/2011)
I'll see if I can't dig up some of my older scripts I used.
I'd be interested in seeing those if you happen to dig them up. It depends...
June 14, 2011 at 3:39 pm
SSIS FINDSTRING becomes CHARINDEX in T-SQL.
SSIS TRIM becomes LTRIM + RTRIM in T-SQL.
The rest have the same names between SSIS and T-SQL so you can look them up in...
June 14, 2011 at 2:53 pm
Dave Ballantyne (6/14/2011)
Its not ANSI_WARNINGS , im guessing you are testing with SET STATISTICS TIME ON , that is your differencehttp://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/11/24/the-observer-effect-in-action.aspx
Thanks for the info but STATISTICS TIME was OFF during...
June 14, 2011 at 2:07 pm
SELECT 1 AS [No reason to get testy...],
1.0 AS [unpaid volunteer trying to help you here]
INTO dbo.[Was it...
June 14, 2011 at 2:04 pm
Viewing 15 posts - 6,091 through 6,105 (of 7,168 total)