Viewing 15 posts - 301 through 315 (of 2,900 total)
This seems to almost work, but the counts are a bit higher than the actual number of 'JOIN' strings.
No time to improve it right now, but might be "good enough"...
October 19, 2020 at 1:56 pm
You inspired me. I'm going to write an article based on this, as some of these things are interesting from a DR standpoint.
The very first recommendation in such...
October 19, 2020 at 1:19 pm
What is the purpose, use & "priority" of the target server ? Does it already have data, or is it a copy into an empty database ?
Is this a 1...
October 19, 2020 at 1:14 pm
THANKS ! Not sure how 'sa' got in the connection string for that 1 job.
".....on the Data Sources tab check the entire connection string for the connection manager...…"
October 12, 2020 at 6:12 pm
Do you have execution plans before & after the slowdown that you can compare ?
Is the amount of data increasing ?
I doubt it's hardware related, but check the server event...
September 17, 2020 at 2:09 pm
Thanks for following up with the solution.
September 1, 2020 at 12:54 pm
table1 exists on 5 different servers and want to combine the result into 1 temp table.
It would be clearer if you specify 5 servers instead of server=xxxxxxx 5 times
server=Server1,...
August 13, 2020 at 3:19 pm
Your 5 select examples look the same to me, so you will get the same result 5 times. Is that intended ?
Or table1 exists on 5 different servers and you...
August 13, 2020 at 1:33 pm
MySQL is different from MS SQL.
What are your goals ? Look for courses that lead towards a specific goal(s).
August 11, 2020 at 2:23 pm
Maybe just increase the length of a variable ?
'X:\Backups\SERVER001\Database0001\Log\SERVER001$SERVER001
_Database001_Log_20200731_203617.trn'
Is not unusually long. Maybe there's a different problem ?
August 3, 2020 at 4:25 pm
Thanks. Now the REAL problem is weeding through all the data. I captured production events for 30 minutes, and got 1 million records.
Then I decided to capture some data changes...
July 30, 2020 at 8:29 pm
They may want a BAT file or something to call the stored procedure.
July 30, 2020 at 4:02 pm
Is there a GUI method to browse, filter the EE_20200729.XEL file I created yesterday ?
I am trying to find some stored procedure calls, triggers and table updates, invoked by a...
July 30, 2020 at 2:42 pm
What app would you use to present the SP to the user so they can run it ?
July 30, 2020 at 2:18 pm
It looks like SSMS Live Data option only works if the session is started or paused ? I did "Stop Session" and want to filer and narrow down data. I...
July 30, 2020 at 1:50 pm
Viewing 15 posts - 301 through 315 (of 2,900 total)