Jeff Moden

Forum Replies Created

Viewing 15 posts - 961 through 975 (of 59,082 total)

Reply To: HTML on the published article is broken

You need to send an email to webmaster@sqlservercentral.com to get this fixed more expeditiously because they don't typically monitor this particular forum and I'm pretty sure they don't have actual...
--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)

November 19, 2023 at 9:16 pm

#4330679
Reply To: How to find second position after decimal

Steve Collins wrote:
Thank you Jeff. 44.9% or 31%? Either way there's no implicit type conversion 🙂
Ken McKelvey's solution in the "Pivot with grouping intervals" topic is interesting. It cross join's a...
--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)

November 19, 2023 at 9:00 pm

#4330676
Reply To: How to find second position after decimal
Steve Collins wrote:
You could test if the modulo .1 of HRS equals zero
```
;WITH cte_data AS (
    SELECT CAST(50.10 AS numeric(5, 2)) AS HRS
  ...
```
--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)
November 18, 2023 at 9:32 pm

#4330265
Reply To: How to find second position after decimal

Nearly duplicate post with an incorrect improvement calculation removed.
--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)

November 18, 2023 at 9:31 pm

#4330264
Reply To: Can Data Save the World?

david.gugg wrote:
Very interesting to think of how differently this concept can be thought about 6 years later than it was originally published. Since then the fact that people use data...
--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)

November 16, 2023 at 12:17 am

#4328488
Reply To: Time Tally Table
Jonathan AC Roberts wrote:
Try installing the table valued function here: https://www.sqlservercentral.com/scripts/a-daterange-table-valued-function
Then to select 15 minute intervals as in your example:
```
SELECT Value
  FROM dbo.DateRange('1900-01-01 00:00', '1900-01-01...
```
--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)
November 16, 2023 at 12:12 am

#4328487
Reply To: estimated # of rows when modification count > 0

With all the automatic query tuning stuff they did in 2022, who knows how the optimizer estimates things now?
It'll be interesting if anyone shows up that actually knows.
--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)

November 14, 2023 at 3:41 am

#4327050
Reply To: Unique Primary Key Linked to Multiple Accounts

yrstruly wrote:
It is joined on the Account numbers, which appears in the table multiple times. Problem is the Unique Primary Key is then mapped to these Account numbers multiple times.
So...
--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)

November 14, 2023 at 2:52 am

#4327024
Reply To: Import ridiculously large CSV file

We "talked" on LinkedIn. I provided a link to "BULK INSERT" and introduced "BatchSize" and "Tablock" to you. You also found "Example f.", which is about how to do things...
--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)

November 13, 2023 at 4:13 pm

#4326797
Reply To: High Deadlock Priority

I have to admit, I'm totally amazed about the number of people that participate on the QoD and on Polls on linked in.
I'm also amazed at the number of wrong...
--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)

November 13, 2023 at 3:48 pm

#4326790
Reply To: Import ridiculously large CSV file
This minor change (IIRC)...
```
BULK INSERT OSPRetail.dbo.DimProduct5
FROM 'C:\Users\User\Downloads\data feed.csv'
WITH ( FORMAT = 'CSV',
FIELDTERMINATOR = ',',
ROWTERMINATOR = 0X0A);
```
Also, read up a bit on the BULK INSERT and learn 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)
November 13, 2023 at 2:53 am

#4326456
Reply To: shrinkfile option not working

sqlguy80 wrote:
Its managed SQL Server Business critical, with the latest version, and MS automated management of Log file.
The issue here is there is purge and archival of data creating lots...
--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)

November 10, 2023 at 1:00 pm

#4325169
Reply To: Time allocation across blocks of time

Phil Parkin wrote:
max266 wrote:
If it was included then yes. Sorry, this is a different data set I put together. But the idea, process, and everything about the data is very similar.
Please...
--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)

November 10, 2023 at 12:36 pm

#4325168
Reply To: How to Efficiently Find and Remove Duplicates in a Large SQL Database?

Piyushbhatt wrote:
I have a large SQL database with millions of records, and I've identified duplicate entries. What's the most efficient way to find and remove these duplicates without compromising database...
--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)

November 10, 2023 at 12:28 pm

#4325149
Reply To: how to reverse comma seprated values.

Phil Parkin wrote:
Thanks, Jeff. I made the assumption that the OP did not have a table 'TBL' containing a single column 'COLUMN1' and therefore that the addition of a suitable PK...
--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)

November 10, 2023 at 12:16 pm

#4325148

Viewing 15 posts - 961 through 975 (of 59,082 total)