Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,351 through 4,365 (of 59,087 total)

Reply To: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

So... here we are near the end of the year 2021. SQL Server 2022 has just been announced, miracles of both hardware and software have and continue to occur, MS...
--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, 2021 at 4:49 pm

#3952736
Reply To: COHESITY for Backup/Restore?

Brian-444611 wrote:
Grant Fritchey wrote:
Jeff Moden wrote:
Along with what Grant has stated and since they said it did "regular" SQL Backups, have them do a test restore using native tools only to prove...
--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 11, 2021 at 3:33 am

#3951467
Reply To: Bulk Insert - Only Half the Records

It would also be helpful if you posted the CREATE TABLE statements for the two target tables and attach a text file with the first 10 or so rows from...
--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 11, 2021 at 3:05 am

#3951284
Reply To: Bulk Insert - Only Half the Records

On of the things that's bugging me about this is that you say that the first import is going to a single column table yet you have a field terminator...
--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 11, 2021 at 3:04 am

#3951017
Reply To: Bulk Insert - Only Half the Records

Brahmanand Shukla wrote:
I found an issue in the code you posted. You may try after correcting it.
Assign a length to the NVARCHAR in the following line of your code. If you'll...
--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 11, 2021 at 2:54 am

#3950764
Reply To: How to retrieve a number in range that matches another number

Did that work for you? "Enquiring minds want to know". 😀

--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, 2021 at 6:37 am

#3949766
Reply To: Bulk Insert - Only Half the Records

Another possibility is if two files were merged. If (IIRC) a "control Z" character is in the file, that signifies the end of the first file and it may not...
--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, 2021 at 6:34 am

#3949765
Reply To: New Index Maintenance Methods Recommended by Microsoft

I wasn't build one file group for each index... it was for one table and it's related indexes but only if those indexes require index maintenance.
You say you have hundreds...
--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 9, 2021 at 10:07 pm

#3949647
Reply To: New Index Maintenance Methods Recommended by Microsoft

ScottPletcher wrote:
Jeff Moden wrote:
ScottPletcher wrote:
Jeff Moden wrote:
As a bit of a sidebar, wouldn't adding more files add to the problem you spoke of previously?
I'm not sure which specific "problem" you're referring to.
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 9, 2021 at 6:08 pm

#3949591
Reply To: Help Converting Query For Hierarchical Data

duffdean wrote:
I have a working query within MySQL based on (Managing Hierarchical Data in MySQL - http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql/). The problem I have is that I need to implement the same functionality on another...
--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, 2021 at 9:28 pm

#3948695
Reply To: Query to fetch top SQL statements

I whole-heartedly agree Michael. Collecting data and knowing what to do with it are two very different things.
I'll also state that while extended events can be useful, it's a total...
--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, 2021 at 8:52 pm

#3948694
Reply To: how testing works in real time environment

shalinipega2 wrote:
I want to know stages of testing.
I know this post is half a decade old but, since it was necro'd and bubbled to the surface, I have to ask......
--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, 2021 at 8:34 pm

#3948693
Reply To: Automate loading data to SQL Server 2016 from Oracle DB
For performance reasons, I wouldn't use a "straight" SELECT from a linked server. Instead, I normally use OPENQUERY as the source for an INSERT INTO.
```
 INSERT INTO...
```
--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, 2021 at 8:20 pm

#3948690
Reply To: Update Column but with Distinct Values
kaj wrote:
This should work, I think:
```
UPDATE t
SET t.CarStatus = '2'
FROM #Test t
INNER JOIN (
    SELECT CarID, MIN(Id) AS Id
    FROM #Test
...
```
--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, 2021 at 8:10 pm

#3948688
Reply To: Monitoring system

sqlguru wrote:
We are setting up Idera SQL DM system to monitor our SQL Server's. So we have availability group setup for the repositories at database level. Looking for option 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)

November 6, 2021 at 7:40 pm

#3948679

Viewing 15 posts - 4,351 through 4,365 (of 59,087 total)