Viewing 15 posts - 5,596 through 5,610 (of 59,068 total)
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...
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...
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...
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)....
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...
February 17, 2021 at 6:40 pm
Never mind. Figured out. I found I cannot delete my own post
So what was the fix you figured out?
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...
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...
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...
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...
February 16, 2021 at 2:03 pm
BAWAAA-HAAAA-HAAAA!!! I'll get the popcorn! 😀
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...
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.
February 16, 2021 at 6:33 am
All of the links I clicked on in your T-SQL site leader to "blogger.com/about".
Did you ever fix the delete vs truncate answers? They were really wrong at the beginning of...
February 16, 2021 at 6:28 am
Viewing 15 posts - 5,596 through 5,610 (of 59,068 total)