Viewing 15 posts - 5,611 through 5,625 (of 59,072 total)
Additional column would suffice.
We have an end to end server inventory collection process - all automated from server collection to data collection from those servers.Servers do get decommisioned...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 18, 2021 at 8:01 pm
I've been asked to take over maintenance of a system (the previous dev has left). I've been looking at the code and I've found this function:
If you pass in...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 18, 2021 at 7:45 pm
Currently, all the detail data is in one table that gets refreshed each month.
Could you post the CREATE TABLE statement for that one table and also identify the column...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 17, 2021 at 11:36 pm
If I am understanding your question correctly:
The main export data output is 85 columns. They must be delimited by the bar character per the recipient's requirements. The end result...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 17, 2021 at 7:14 pm
How can I get the first error? Error_number only returns 3013 RESTORE DATABASE is terminating abnormally.
When the actual error is 3176 File 'M:\SQLData\SQL2016\SolarWindsOrion_Cortex_document' is claimed by 'Cortex_documents2'(4) and 'Cortex_documents1'(3)....
--Jeff Moden
Change is inevitable... Change for the better is not.
February 17, 2021 at 6:49 pm
You're a good and thoughtful man, Mike. Thank you for asking.
I've always said that DelimitedSplit8k (and DelimitedSplitN4k) was created by the community and I just happen to be the prime...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 17, 2021 at 6:40 pm
K. Thanks.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2021 at 8:57 pm
Never mind. Figured out. I found I cannot delete my own post
So what was the fix you figured out?
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2021 at 8:11 pm
I've also looked at some other SQL Users Groups to see how they work, and thus far I haven't seen any that still meet.
The New...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2021 at 5:51 pm
I can't speak for anyone else but I've found that different applications and their different requirements frequently come and go on our systems. Some even have different Recovery Models for...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2021 at 5:50 pm
we are saying, that #1 and #3 are correct, not #3 and #4.
LEAD with descending order is the same as LAG with ascending order (except that the returned rows...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2021 at 5:28 pm
Ok... so to those that are saying that answer #4 is also correct, that's incorrect. Here's the output from answer #3 and answer #4. #4 is incorrect if you pay...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2021 at 2:03 pm
BAWAAA-HAAAA-HAAAA!!! I'll get the popcorn! 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2021 at 1:31 pm
Yes... they're in the "Default Trace" but, on a busy system, they not there for very long. You'd have to build a regularly scheduled sampler for that or some custom...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2021 at 6:37 am
...but I want more access to skills building & problem activities.
So start studying and answering forum questions. You won't find more real world problems anywhere else.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2021 at 6:33 am
Viewing 15 posts - 5,611 through 5,625 (of 59,072 total)