Viewing 15 posts - 46 through 60 (of 9,641 total)
Have you considered using SSRS and putting a page break based on customer id and save as a PDF or as Excel?
December 28, 2017 at 4:39 pm
Can you post the table definitions including collation for character columns?
If your import table has a case-sensitive collation and your destination table does not you could still get...
December 28, 2017 at 4:13 pm
Here's how I get Foreign Key info:
SELECT
FK.name,
SCHEMA_NAME(FK.schema_id) AS schemaName,
OBJECT_NAME(FK.parent_object_id) AS parentTableName,
parentCols.name AS parentColumnName,
OBJECT_NAME(FK.referenced_object_id) AS referencedTableName,
...
December 28, 2017 at 4:03 pm
December 6, 2017 at 12:26 pm
December 1, 2017 at 9:54 am
Thanks for your reply. Yes, this code has been returning about 15 million rows...which...
December 1, 2017 at 7:53 am
November 16, 2017 at 8:22 am
November 16, 2017 at 8:09 am
Jo Pattyn - Tuesday, October 17, 2017 2:53 AMSorry polluting sql 2017 administration. Why can't migrating SSRS to 2017 be simple?
If things...
October 17, 2017 at 6:37 am
October 13, 2017 at 6:48 am
October 3, 2017 at 5:00 pm
September 25, 2017 at 11:37 am
Okay, I didn't delve deeply into what was different because the row counts returned where in the 300K range. Basically the difference is that when run in serial the query...
September 15, 2017 at 4:31 pm
Is that the plan from DEV or production? Honestly there isn't a lot to see in that pan because everything is going across a linked server. There are a number...
September 15, 2017 at 12:47 pm
No worries. The estimated execution plan(s) would be fine. This article explains how to create the execution plan and then you can just save it as a .sqlplan...
September 15, 2017 at 12:39 pm
Viewing 15 posts - 46 through 60 (of 9,641 total)