Jeff Moden

Forum Replies Created

Viewing 15 posts - 946 through 960 (of 59,063 total)

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
Reply To: how to reverse comma seprated values.

rajemessage 14195 wrote:
hi,
i have coma separated vales in a table. what i want to reverse it like 'CLP,CAD,GBP' pls tell me how it can be done WITH OUT USING XML IN...
--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 11:44 am

#4325138
Reply To: Changing the PK - I

Great question, Steve. It gave me an idea for something else that I need to do.
--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 8, 2023 at 8:17 pm

#4323998
Reply To: IX fragmentation and Updating Stats

sqlguy80 wrote:
Though its Azure MI Business critical , I see fragmentation, Any script to identify which IX's need to be rebuilt ,as Frag is over 50%.
I will add REBUILD 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)

November 7, 2023 at 8:08 pm

#4323270
Reply To: shrink data file with low priority

Jeffrey Williams wrote:
Or - you could add a file and use EMPTYFILE on the original file. Once the original file is empty it can then be removed.
Have you tried this when...
--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 6, 2023 at 11:34 pm

#4322599
Reply To: shrink data file with low priority

Removed... I somehow duplicated the post below.
--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 6, 2023 at 11:33 pm

#4322598
Reply To: The SQL Server Windows NT - 64 bit" in Task Manager: memory high 10 gb cpu 100 %

Grant Fritchey wrote:
Why are you duplicating this question? I don't see a link suggesting this is spam, but the answers to that almost identical question are going to be what...
--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 5, 2023 at 8:51 pm

#4321802
Reply To: Replacing last few characters with another value.

"Bumping" this post because it's hidden by the "Don't display the first post of a new page" problem this forum has, which I wish they'd fix. This has been 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 4, 2023 at 10:27 pm

#4321317
Reply To: Convert columns result into rows with comma and single quotes

The issue with using QUOTENAME is that it returns the result as an NVARCHAR(258). The OP started out with a VARCHAR().
In this case, the resulting STRING_AGG() returns an NVARCHAR(4000).
--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 4, 2023 at 10:14 pm

#4321316
Reply To: Newly created login can not see/connect to user database

Just "bumping" this because of the "1 Post on another Page won't display" problem that this forum has. I really wish they'd fix this issue. 🙁
--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 4, 2023 at 10:03 pm

#4321315

Viewing 15 posts - 946 through 960 (of 59,063 total)