Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,801 through 1,815 (of 59,067 total)

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
Reply To: slow performing query

vsamantha35 wrote:
RCSI is enabled for this database. However, writers are blocking writers. INSERTs and DELETE's,
Sometimes, even a good healthy dose of magic pixie dust can't break through a mountain of...
--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:51 pm

#4155606
Reply To: Writing a line for each day of month???

jbalbo wrote:
I see ur point, but wouldn't I be safe if I ran it thru something like Ssrs using a date parameter?
In a word, No. There are much better ways...
--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 1:33 am

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

frederico_fonseca wrote:
regarding https://www.sqlservercentral.com/forums/topic/writing-a-line-for-each-day-of-month
can someone post a link to an older thread the OP created that does what it's asking (again) to be given to them.
older thread is https://www.sqlservercentral.com/forums/topic/how-do-i-write-a-record-for-each-day-in-a-date-range
I can't reply...
--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 28, 2023 at 11:13 pm

#4155224
Reply To: Writing a line for each day of month???

jbalbo wrote:
Thank You Michael,
The saddest part of the answer is I submitted the question 5 years ago!!! LOL!!!!
Shows how long I haven't used it...
Thanks Again
I recommend that you don't make...
--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 28, 2023 at 10:58 pm

#4155220
Reply To: slow performing query

p.s. I also notice in one of your previous posts above that the table has 4 non-clustered indexes... that's likely where the page splits are coming from. Considering the very...
--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 28, 2023 at 7:50 pm

#4155194

Viewing 15 posts - 1,801 through 1,815 (of 59,067 total)