Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,786 through 1,800 (of 59,067 total)

Reply To: SQL - Grouping SQL output in 5 minute intervals
Yep...
Here's the cleaned up test data with a couple of extra rows for the "xx:00" proof...
```
--    DROP TABLE IF EXISTS dbo.Sell
GO
 CREATE TABLE dbo.SELL...
```
--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 3, 2023 at 12:30 am

#4156212
Reply To: SQL 2016 updates

jchendorain wrote:
Hello, so Microsoft has two Feb 2023 SQL updates listed under the same CVE. 5021128 Security update for SQL Server 2016 SP3 Azure Connect Feature Pack+GDR, and 5021129 Security...
--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 10:43 pm

#4156185
Reply To: Master Data - Hierarchies Creation, Change and Maintenance

If the hierarchies are DAGs (Directed Acyclic Graphs) with no loop backs, no "crossed legs", and are true "Adjacency List" (parent/child only) hierarchies, then I recommend that you study 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)

March 2, 2023 at 10:41 pm

#4156184
Reply To: Random Number Generating

I just wanna know what he actually wants. 😀
--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 10:33 pm

#4156180
Reply To: update stats vs rebuilding indexes

vsamantha35 wrote:
#1) In terms of I/O and time, which is faster? running Index Rebuilds or Running Updatestats or is it depens on case to case?
#2) I have a database called...
--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 10:22 pm

#4156168
Reply To: Random Number Generating

Jason A. Long wrote:
Jeff Moden wrote:
p.s. This is really going to be fun when they need another 10 million unique random values to fold into the first 10 million. 😀
It shouldn't be too...
--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 9:56 pm

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

Agreed. That would also decide if the last 5 minute period appeared to be in the next hour or not if hourly calculations from the original average calculations needed 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 9:20 pm

#4156155
Reply To: Random Number Generating

p.s. This is really going to be fun when they need another 10 million unique random values to fold into the first 10 million. 😀
--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 9:16 pm

#4156153
Reply To: Random Number Generating

Jason A. Long wrote:
I read it as "the number should be between 10 and 15 digits in length and the first two digits must be 11".
Some clarification from the OP would 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 9:09 pm

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

Yep... and he never got an answer to his question on any of those. On one of the earlier ones, he did a work around by using VBA , but...
--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 9:01 pm

#4156150
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

Viewing 15 posts - 1,786 through 1,800 (of 59,067 total)