Viewing 15 posts - 4,441 through 4,455 (of 9,712 total)
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
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
Viewing 15 posts - 4,441 through 4,455 (of 9,712 total)