Viewing 15 posts - 5,446 through 5,460 (of 13,873 total)
Everyone should note that this question has previously been asked, and answered ... in a slightly different form ... here.
July 5, 2017 at 6:46 am
July 5, 2017 at 6:42 am
I have been doing some reading online and discovered the Lead and Lag Functions. ...
July 4, 2017 at 1:28 pm
Can we assume that there is no possibility whatsoever that the proc will be called twice (or more) at the same time?
If not, you need to add some code...
July 4, 2017 at 1:13 pm
July 4, 2017 at 10:24 am
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
Viewing 15 posts - 5,446 through 5,460 (of 13,873 total)