Viewing 15 posts - 4,441 through 4,455 (of 9,715 total)
Lynn Pettis (5/10/2012)
Brandie Tarvin (5/10/2012)
I think I shall strap myself to the porkchop launcher and launch...
May 10, 2012 at 7:34 am
Wow. I come back to The Thread and find the lot of you talking blasphemy.
I think I shall strap myself to the porkchop launcher and launch myself out of reach...
May 10, 2012 at 6:23 am
Stefan Krzywicki (4/23/2012)
Also congratulations! First standalone work, that's awesome! Love the title and the cover and I look forward to getting it.
Thank you. I appreciate it.
April 23, 2012 at 11:55 am
Stefan Krzywicki (4/23/2012)
Brandie Tarvin (4/23/2012)
Hijacking the thread for another book announcement.You can read the details on the top post of my Google+ stream here: Legend of the Beemen
That'll teach...
April 23, 2012 at 11:53 am
Hijacking the thread for another book announcement.
You can read the details on the top post of my Google+ stream here: Legend of the Beemen
April 23, 2012 at 11:18 am
Eugene Elutin (4/23/2012)
Try to drop and recreate destination table with SET ANSI_PADDING OFF, it's still supported in SQL 2012
Note to OP: If you have data in this table and want...
April 23, 2012 at 6:10 am
Why not do a bit of code before the restore in an IF EXISTS type of statement?
All you have to do is search the sys.databases table where source_database_id IS...
April 23, 2012 at 6:01 am
When you say Clustered Scan or Index Scan, as Gail already mentioned, a Clustered Scan is a Clustered Index Scan / Table Scan. You can also have Index Scans on...
April 23, 2012 at 5:54 am
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
Viewing 15 posts - 4,441 through 4,455 (of 9,715 total)