Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,656 through 5,670 (of 59,072 total)

Reply To: Audit

I can't help but notice the irony here.. Interesting question coming from someone with a handle of "sqlguru". 😉
--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 8, 2021 at 10:31 pm

#3842674
Reply To: Intellisense for dropping temp tables?

Cool. Thanks for the feedback. Funny setting name, though. I would never have thought to look under "Auto List Members". Members aren't Objects. Gotta love the lingo. 😀
That might also...
--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 8, 2021 at 10:02 pm

#3842672
Reply To: A Simple Formula to Calculate the ISO Week Number

Heh... I'm no longer surprised by such things. For example, the came out with EOMonth, which has the very problem we're talking about. They didn't come out with an SOMonth...
--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 8, 2021 at 6:59 pm

#3842603
Reply To: Intellisense for dropping temp tables?

A lot of things have changed in SSMS since it became a separate product and they continue to "ditz" with it and, so far, a lot of it has been,...
--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 8, 2021 at 6:38 pm

#3842596
Reply To: Query optimization

Apparently, the OP has left the building.
--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 8, 2021 at 4:21 pm

#3842532
Reply To: A Simple Formula to Calculate the ISO Week Number
Thanks. I'll look at it in a bit more detail later but my first impression is that the following line of code in the CROSSAPPLY is incorrect.
```
cast(dateadd(wk,datediff(wk,0,'01/04/'+iso.yr),0)+((iso.wk)*7)-1...
```
--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 8, 2021 at 4:19 pm

#3842531
Reply To: A Simple Formula to Calculate the ISO Week Number

Steve Collins wrote:
Is this still the best way to do this in 2021? Google landed me at another SSC Forum from 2005, which I can't find anymore, and now I'm using...
--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 8, 2021 at 2:34 pm

#3842493
Reply To: Tough Interview Questions

I totally agree that "outlook, attitude, motivation and method" are incredibly important. However, there have to be technical questions/discussions, as well. I've found that they're actually important in me the...
--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 8, 2021 at 2:30 pm

#3842492
Reply To: Allow SQLSaturdays to personalize

codegumbo wrote:
This may seem insignificant in light of all of the decisions that need to be made about the future of events, but one of the things that was always...
--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 8, 2021 at 2:09 pm

#3842487
Reply To: Do it. Try it. Fix it.

Yep... that's the way it is... not the way it should be. That's exactly what I'm talking about. That junk methodology needs to be fixed.
--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 7, 2021 at 12:00 am

#3842022
Reply To: Moving Items into Columns

If you post your data in a readily consumable format, you're more likely to get a coded answer for this. Please see the first link in my signature line below...
--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 6, 2021 at 11:44 pm

#3842019
Reply To: Evaluating Amazon RDS Instance

IIRC, you have no control over backups and, if you want a single database to be restored, you have to request that the whole instance be restored.
Unless you want almost...
--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 6, 2021 at 11:37 pm

#3842018
Reply To: Are the SQL Server "Error Logs" (residing under SQL Server Agent) backed up?

Instead of farting around with files, build a database to hold the error logs in tables and do something like what the fellow at the following link did.
https://www.mlakartechtalk.com/how-to-load-sql-server-error-log-into-table-for-analysis/
You could...
--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 6, 2021 at 11:16 pm

#3842014
Reply To: Do it. Try it. Fix it.

Sergiy wrote:
F.clems, if you need to use tricks and manipulation to bypass the system in order to get a good result, then the system is broken, don't you think?
Totally agreed. ...
--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 6, 2021 at 9:51 pm

#3841994
Reply To: Do it. Try it. Fix it.

Sergiy wrote:
Jeff, what you describe is the essence of Agile Development, as it's done nowadays.
to fix the quality of software product the industry has to outlaw terms "agile", "sprint", etc.
You...
--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 6, 2021 at 9:46 pm

#3841993

Viewing 15 posts - 5,656 through 5,670 (of 59,072 total)