Viewing 15 posts - 4,456 through 4,470 (of 9,722 total)
eddy-961438 (4/23/2012)
its a shame because it works very fast.
That's why the command works so fast, because it's not transforming data.
April 23, 2012 at 5:16 am
What I'm about to suggest may or may not help you. Performance is dependent on your schema and data. So test this out for performance before you put it into...
April 23, 2012 at 5:14 am
Your biggest issue with converting the reports as BIDS 2k8 wants you to is that you will never be able to open them with 2k5 SSRS tools. As software is...
April 23, 2012 at 5:11 am
What you might consider is either a subquery, CTE, or TempTable for your initial Tally Table pull. Pull just the numbers from the Tally Table that you need and only...
April 23, 2012 at 5:06 am
This definitely looks like a job for dynamic SQL. The thing to remember, though, is that the PIVOT command requires some sort of aggregation, which may skew the result set.
April 23, 2012 at 4:52 am
It also depends on what you mean by "add." Are you referring to the Create Table statement or are you referring to adding the column to a resulting data set,...
April 23, 2012 at 4:48 am
Your solution is to either don't use Bulk Insert (use SSIS and trim the data on import) or import the data into a staging table, trim the spaces off, then...
April 23, 2012 at 4:47 am
I am probably phrasing this wrong (and someone will gently tap me upside the head with the pork chop launcher to correct me)...
From what I've seen, SQL has a...
April 20, 2012 at 11:08 am
SQLRNNR (4/20/2012)
Brandie Tarvin (4/20/2012)
Has anyone heard of a company called Kaseya? They apparently do IT software, user conferences, and webinars, but I can't find much more out about...
April 20, 2012 at 8:32 am
Unrelated question:
Has anyone heard of a company called Kaseya? They apparently do IT software, user conferences, and webinars, but I can't find much more out about them - reviews,...
April 20, 2012 at 4:59 am
Grant Fritchey (4/20/2012)
New rule, Threadizens, if you go down at a conference, you have to get word back to another Threadizen. Some of us actually do care (a little).
More than...
April 20, 2012 at 4:56 am
I am starting to do guest posts on my writing blog and I'm wondering if any of you Threadzian authors (who have done editing or writing on SQL Server books)...
April 19, 2012 at 6:31 am
Stefan Krzywicki (4/18/2012)
SQLRNNR (4/18/2012)
Stefan Krzywicki (4/18/2012)
jcrawf02 (4/18/2012)
Stefan Krzywicki (4/18/2012)
Scope for variables in SSIS are utter crap, it'd be better if scope didn't even exist here. Yes,...
April 19, 2012 at 4:24 am
How about a slight change of subject. Still "worst questions" but of the humorous sort.
We've all heard about the admin assistant who switched from typewriters to computers and started whiting...
April 18, 2012 at 12:13 pm
Viewing 15 posts - 4,456 through 4,470 (of 9,722 total)