Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,231 through 4,245 (of 59,087 total)

Reply To: Implementing Date Calculations in SQL

Yep. Totally agreed that the 52/53 week things get folks a whole lot closer than most but, as you say, what do people thing they're actually comparing? Even the almighty...
--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)

December 15, 2021 at 11:24 pm

#3964174
Reply To: Determine Start/End date of given (ISO)week and year

Thanks for the feedback, especially after a whopping 16 years! 😀
While the code I posted still works, I've developed a real hate for the "wk" date-part. I also normally don't...
--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)

December 15, 2021 at 10:58 pm

#3964167
Reply To: Query Run Time

Guess the op lost interest.
It also looks like we've had a problem with DBCC TIMEWARP on this thread. The original post was on 14 Dec 2021 at 11:59PM.
Even the Op's...
--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)

December 15, 2021 at 3:46 pm

#3963957
Reply To: Implementing Date Calculations in SQL

jparada wrote:
Hi, I have been looking for the most correct way to handle this kind of analytics (periods) with sql server, and this article has been the closest to get...
--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)

December 15, 2021 at 2:01 pm

#3963903
Reply To: Query Run Time

Not to mention that the code included in the execution plan is frequently truncated or a bit "warped". I recommend always including the code separately. It doesn't take long to...
--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)

December 14, 2021 at 6:02 pm

#3963590
Reply To: permissions

ScottPletcher wrote:
"I review it". How long does THAT take?
And why does it need reviewed for "safety" if they don't have the permissions to change anything on the instance??
What on Earth...
--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)

December 14, 2021 at 4:45 am

#3963330
Reply To: permissions

ScottPletcher wrote:
frederico_fonseca wrote:
ScottPletcher wrote:
Hold on. I explicitly stated that auditors should not be able to change anything on the system. Talking about giving auditors "sysadmin" is a straw man.
Scripts that capture...
--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)

December 14, 2021 at 12:55 am

#3963296
Reply To: invoke-sqlcmd : Cannot open database requested by the login. login. Login failed

MillionQueries wrote:
Hi Jeff,
Thanks for your reply. The script i included here is just a part of the long script. I did not see any other way to achieve what i...
--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)

December 14, 2021 at 12:51 am

#3963295
Reply To: How can i give Grant permission for synonyms from another database in same server.

Brandie Tarvin wrote:
But why would you need synonyms on the same server? It's easy enough for users just to use Database.Schema.Table conventions in their code, isn't it?
You'll just love...
--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)

December 14, 2021 at 12:39 am

#3963294
Reply To: Arithmetic overflow error converting expression to data type smallint

water490 wrote:
Hi everyone
I am getting error
Arithmetic overflow error converting expression to data type smallint
The calculation I am doing is producing very small numbers like 0.0000005328.
How can I fix the calculation...
--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)

December 13, 2021 at 7:34 pm

#3963203
Reply To: invoke-sqlcmd : Cannot open database requested by the login. login. Login failed

Why are you doing this in PowerShell?
--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)

December 13, 2021 at 7:29 pm

#3963198
Reply To: permissions

ScottPletcher wrote:
An "audit" that only allows what the DBA wants to run is not a true audit.
Correct. That's why I have them witness the runs. And, as a DBA, I...
--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)

December 13, 2021 at 7:22 pm

#3963196
Reply To: adding hh:mm:ss time to yyyy-mm-dd hh:mm:ss format

DaveBriCam wrote:
What format would you prefer the data?
READ THE ARTICLE AND YOU'LL KNOW AS LEAST ONE WAY!
--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)

December 13, 2021 at 6:56 pm

#3963184
Reply To: Filtering/ searching in forum topics?

Helene Kastor wrote:
We need a reference value to see which scripts has a high popularity because we didnt want to search in more than thousand scripts. We only want the scripts...
--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)

December 13, 2021 at 6:52 pm

#3963183
Reply To: SQL Server Execution Plans, Third Edition, by Grant Fritchey

Grant Fritchey wrote:
Jeff Moden wrote:
Grant,
Didn't you say that you were coming out with the 4th Edition sometime in the first half of next year (2022)?
No plans to update the execution plans book...
--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)

December 13, 2021 at 6:40 pm

#3963178

Viewing 15 posts - 4,231 through 4,245 (of 59,087 total)