Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,816 through 1,830 (of 59,082 total)

Reply To: SQL - Grouping SQL output in 5 minute intervals

Jeffrey Williams wrote:
Jeff Moden wrote:
Your timestamp column is a UNIX timestamp based on Seconds. Just use integer division to divide that number by 300 and you'll get the GROUP BY value 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)

March 2, 2023 at 8:43 pm

#4156138
Reply To: Random Number Generating

Jason A. Long wrote:
Jeff Moden wrote:
sathishkm wrote:
reduce the length to
The numbers should begin with 11. The minimum length of the number should be 10 The maximum length of the number should be 15...
--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)

March 2, 2023 at 8:40 pm

#4156137
Reply To: SQL - Grouping SQL output in 5 minute intervals

~~Your timestamp column is a UNIX timestamp based on Seconds. Just use integer division to divide that number by 300 and you'll get the GROUP BY value for your Average.~~
Edit: ...
--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)

March 2, 2023 at 7:43 pm

#4156119
Reply To: Random Number Generating

sathishkm wrote:
reduce the length to
The numbers should begin with 11. The minimum length of the number should be 10 The maximum length of the number should be 15 Need 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)

March 2, 2023 at 7:32 pm

#4156118
Reply To: Question related to functions

mjohnson 71479 wrote:
Is it possible to have a function that is stored somewhere other than in Programmability-> Functions -> Scalar-valued Functions of each database like in the master database and...
--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)

March 2, 2023 at 6:52 pm

#4156097
Reply To: Random Number Generating
sathishkm wrote:
Hi All,
I need to generate random unique numbers for 10 million records.
Here is my requirement
1. The numbers should begin with 11.
2. The minimum length of the number should be...
--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)
March 2, 2023 at 6:43 pm

#4156094
Reply To: Are the posted questions getting worse?

frederico_fonseca wrote:
I called him out on the fact that he had 4 threads asking exactly the same thing - he didn't like it
https://www.sqlservercentral.com/forums/topic/ssrs-rendering-format-excel-change -- I made the comment on this...
--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)

March 2, 2023 at 6:35 pm

#4156091
Reply To: SQL Restart sometimes fixes the perf issue. why?

Have you simply tried clearing proc cache for the database that has the code that's causing you fits, which would cause a recompile of your all the code for that...
--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)

March 2, 2023 at 6:19 pm

#4156083
Reply To: Code to sum hours and minutes (varchar), 800,000 rows.

Teewhy wrote:
What is the code to sum this row of data (trip duration in hours and minutes, and about 800,000 rows). Characters are varchar, and I have tried casting based...
--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)

March 2, 2023 at 6:03 pm

#4156079
Reply To: Question related to functions

Lynn8968 wrote:
I faced similar kind of issue last time
Since half of your replies have been flagged as SPAM and they all seem to be in the same vein of acknowledgement...
--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)

March 1, 2023 at 11:06 pm

#4155692
Reply To: Why do cloud companies (in particular) have massive SKOs every year?

kusatvaky wrote:
Can any enlightened cloud industry folk let me know why enterprise tech companies - particularly those cloudy ones - LOVE having a big, massive, expensive Sales Kick Off event...
--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)

March 1, 2023 at 10:55 pm

#4155683
Reply To: slow performing query

vsamantha35 wrote:
Jonathan AC Roberts wrote:
Again, thanks everyone for the support without judging. Thanks.
Heh... ah... but we ARE judging. 😀 The third party code and database design sucks. 😀 😀 😀
--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)

March 1, 2023 at 9:44 pm

#4155671
Reply To: Are the posted questions getting worse?

Michael L John wrote:
Is it Monday? It seems like Monday.
One of my DBA's set up a SQL account, with db_owner on a database in production. The contractors have now raised havoc with...
--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)

March 1, 2023 at 8:11 pm

#4155633
Reply To: Will ChatGPT Write Our Queries?

Heh... "To err is human.... to really *&*&%^$%! things up, you need a computer". 😀
--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)

March 1, 2023 at 8:01 pm

#4155630
Reply To: slow performing query

p.s. SQLProfiler isn't "dangerous". People that don't know what they're doing with either SQLProfile or Extended Events are what's dangerous. 😀
--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)

March 1, 2023 at 7:54 pm

#4155607

Viewing 15 posts - 1,816 through 1,830 (of 59,082 total)