Viewing 15 posts - 46 through 60 (of 9,639 total)
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
Could be a server setting, but most likely it is because of different statistics. Update stats on the dev server and see what happens.
If you post the plans...
September 15, 2017 at 12:18 pm
Viewing 15 posts - 46 through 60 (of 9,639 total)