Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,611 through 5,625 (of 59,072 total)

Reply To: Server identification

mtz676 wrote:
Additional column would suffice.
mtz676 wrote:
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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 18, 2021 at 8:01 pm

#3846929
Reply To: Can anyone explain the design decision here?
edwardwill wrote:
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...
- This reply was modified 5 years, 4 months ago by Jeff Moden. Reason: Added the p.s. for clarification
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
February 18, 2021 at 7:45 pm

#3846913
Reply To: Custom Header Row in Query Result

usererror wrote:
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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 17, 2021 at 11:36 pm

#3846490
Reply To: Custom Header Row in Query Result

usererror wrote:
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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 17, 2021 at 7:14 pm

#3846391
Reply To: Database Restore Errors

Darryl Wilson wrote:
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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 17, 2021 at 6:49 pm

#3846373
Reply To: DelimitedSplit8K License Question

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 17, 2021 at 6:40 pm

#3846368
Reply To: Subscription owner and multiple subscriptions

K. Thanks.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 16, 2021 at 8:57 pm

#3845822
Reply To: Subscription owner and multiple subscriptions

sqlfriend wrote:
Never mind. Figured out. I found I cannot delete my own post
So what was the fix you figured out?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 16, 2021 at 8:11 pm

#3845807
Reply To: Is there room for independent SQL or Data Integration based User Groups?

Tom Uellner wrote:
Jeff Moden wrote:
Tom Uellner wrote:
samalex wrote:
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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 16, 2021 at 5:51 pm

#3845753
Reply To: Question related to architecture

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 16, 2021 at 5:50 pm

#3845752
Reply To: Finding the last month's values

Thomas Franz wrote:
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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 16, 2021 at 5:28 pm

#3845739
Reply To: Finding the last month's values

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 16, 2021 at 2:03 pm

#3845667
Reply To: Finding the last month's values

BAWAAA-HAAAA-HAAAA!!! I'll get the popcorn! 😀
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 16, 2021 at 1:31 pm

#3845627
Reply To: Who modified my Database?

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 16, 2021 at 6:37 am

#3845508
Reply To: We need to move beyond SQL Server...

residentx wrote:
...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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 16, 2021 at 6:33 am

#3845506

Viewing 15 posts - 5,611 through 5,625 (of 59,072 total)