Viewing 15 posts - 796 through 810 (of 1,999 total)
What about storing it in the ring_buffer and just pulling it out of there?
Am I totally missing the purpose of Extended Events? I thought they were supposed to be...
October 21, 2019 at 3:44 pm
as a test, try writing it to a UNC path rather than a mapped drive
\\servername\sharename\filename.txt
October 21, 2019 at 11:16 am
so
select columnA, case when column a<>1 then columnb else 0 end as colb from mytable
but your spreadsheet results don't match what you are asking - maybe it's a language barrier...
October 21, 2019 at 8:11 am
Being honest - why bother with the log file?
I have an operator and alerts set up for all jobs... I also have a script that checks the last run status...
October 21, 2019 at 7:58 am
I also saw those double smashed and tested it... It works fine
October 18, 2019 at 5:24 pm
I'm curious... If you had a low power laptop, how many of you would use azure for the heavy lifting.
My surface is just a gateway to either on premis...
October 18, 2019 at 4:09 pm
your best bet is to set up a domain group and give that group permissions in SQL for your database.
then your domain admins can add other users to the group...
October 18, 2019 at 2:14 pm
I use a company issues Surface Pro, and I would not recommend one of these, as there are always issues with RDP on this thing, where it doesn't...
October 18, 2019 at 1:54 pm
you need to post the error message in full (do it in plain text)- it is chopped off on your print screen
this is step 2 of that job - your...
October 18, 2019 at 1:26 pm
I have a company issued Surface Pro I7 with 16Gb - the docking station runs 2 additional 27" monitors so I have 3 in total.
it is great to take to...
October 18, 2019 at 8:04 am
high cpu is most likely missing indexes, causing the cpu to sort. Or a rogue function.
it's not memory
October 17, 2019 at 6:30 pm
this is hugely complicated. But i would say 90% is not related to max memory.
October 17, 2019 at 6:27 pm
This looks like you are trying to do an UPDATE. If so, then
UPDATE YourTable
SET columnB = CASE
...
October 17, 2019 at 6:22 pm
This looks like you are trying to do an UPDATE. If so, then
UPDATE YourTable
SET columnB = CASE
...
October 17, 2019 at 4:02 pm
extended events have always puzzled me - in theory they are better than a profiler trace, but the display format and functionality is less friendly
personally i'd use a profiler trace...
October 17, 2019 at 12:43 pm
Viewing 15 posts - 796 through 810 (of 1,999 total)