Viewing 15 posts - 5,461 through 5,475 (of 13,879 total)
Try this & see whether it helps:
SELECT
ObjName = OBJECT_NAME(referencing_id)
, referenced_database_name
FROM sys.sql_expression_dependencies
WHERE referenced_database_name IS NOT NULL;
July 4, 2017 at 9:50 am
If you are happy to post the plan here as a .sqlplan attachment, someone here may be able to help you (but bear in mind the date ... not many...
July 4, 2017 at 8:33 am
all other jobs perform the same if not slightly better.
this particular calls a...
July 4, 2017 at 8:21 am
July 4, 2017 at 7:51 am
I am currently in a situation whereby i have migrated 2 databases from SQL...
July 4, 2017 at 7:48 am
Here's one way. It uses an in-line dates table (thanks, Rob Farley), joins that to your data and finally groups it.
Be sure to set the start and end dates...
July 4, 2017 at 6:13 am
July 4, 2017 at 5:47 am
Does it sometimes work OK, or does it fail every time?
July 3, 2017 at 12:49 pm
July 3, 2017 at 12:25 pm
how to query dynamic values to include only row that match ALL items.
'Select *...
July 3, 2017 at 10:22 am
I see that you have built the package with 64 bit runtime on and...
July 3, 2017 at 10:13 am
July 3, 2017 at 10:06 am
Please note that you have posted in the SQL Server 2016 forum, and that your comment about lag/lead is therefore somewhat puzzling. Why did you not post in the forum...
July 3, 2017 at 7:08 am
June 30, 2017 at 5:58 pm
June 30, 2017 at 11:03 am
Viewing 15 posts - 5,461 through 5,475 (of 13,879 total)