Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,591 through 1,605 (of 59,099 total)

Reply To: How to get top 100 values of a col concatenated in a variable in sqlserver?

@rajemessage 14195 ,
Enquiring minds want to know... did the non-XML method work for you?😋

--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)

April 12, 2023 at 11:11 pm

#4173200
Reply To: Can SSIS Check for Viruses?

Michael L John wrote:
Does anyone realize that if the docs are stored on the file system as opposed to a blob in a table, the need to scan them is then part...
--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)

April 12, 2023 at 2:56 pm

#4172954
Reply To: Big Data Downsides

Heh... I remember my Grandmother telling me when I was quite young, "Figures can lie... and liars figure". She was so right even back in the late 50's when she...
--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)

April 12, 2023 at 2:24 pm

#4172945
Reply To: How to get top 100 values of a col concatenated in a variable in sqlserver?

rajemessage 14195 wrote:
we do not want to use xml. so pls tell me with out it?
At least read the latest posts. 🙁 Kaj wrote a solution for you and I tweaked...
--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)

April 12, 2023 at 2:15 pm

#4172938
Reply To: Waitfor Threads

You've just gotta love people that give a super low rating to an article or QoTD without leaving a reason. 🙁 I thought this was a great question because 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)

April 12, 2023 at 2:03 pm

#4172931
Reply To: The place of SMALLDATETIME

sean redmond wrote:
The rounding up of the last 30 seconds to the next hour is not a problem.
...
And as for space, if we have 100GB of data, then we have 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)

April 12, 2023 at 1:34 pm

#4172915
Reply To: Copy DB from Prod to Test !!

Lidou123 wrote:
But users want to test with real data.
Then you really, really need to make sure that security is as air-tight as it is in production and management needs 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)

April 12, 2023 at 1:23 pm

#4172908
Reply To: Looking for recompiling stored procedures

@Brandie...
The code at the following link, written by Jonathan Kehayias, has been a huge help on occasion.
https://www.sqlskills.com/blogs/jonathan/identifying-high-compile-time-statements-from-the-plan-cache/
As one example, one of the screens in an app that our folks wrote...
--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)

April 12, 2023 at 4:23 am

#4172634
Reply To: Copy DB from Prod to Test !!

MMartin1 wrote:
For any data you had to delete, anything with personally identifiable information, there are a couple of tools that can generate data for you to use in testing 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)

April 12, 2023 at 3:52 am

#4172625
Reply To: Copy DB from Prod to Test !!

ZZartin wrote:
Why is it acceptable that a test environment is less secure than a production environment?
It's not, IMHO, and I don't see anywhere in the thread above where that was...
--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)

April 11, 2023 at 11:11 pm

#4172535
Reply To: How to get top 100 values of a col concatenated in a variable in sqlserver?
kaj wrote:
As the OP want an opinion about the two code options presented, i.e.
Option 1:
```
DECLARE @strcol1 varchar(max), @intco11 int

SELECT @strcol1 += ','+CAST(col1 AS VARCHAR(20)),  @intco11=col1 
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)
April 11, 2023 at 8:10 pm

#4172456
Reply To: Find the records based on group by Student ID

ScottPletcher wrote:
I tend to write these things to allow any combination of values later, so I stick with individual checks. For example, suppose later they want to check for status...
--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)

April 11, 2023 at 7:27 pm

#4172442
Reply To: The place of SMALLDATETIME

sean redmond wrote:
I'm not that worried about space per se. The column will be one of metadata and while seconds would be nice to have, accuracy to hours & minutes is...
--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)

April 11, 2023 at 7:20 pm

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

Steve Jones - SSC Editor wrote:
I've been having debates with various tech people about ChatGPT. In many cases, it's not worse than the average (or below avg) dev. Not sure what to think 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)

April 11, 2023 at 6:07 pm

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

Eirikur Eiriksson wrote:
WayneS wrote:
frederico_fonseca wrote:
I have to say that if we did mix the good things of all of them we would have an really really outstanding product.
So... what are you...
--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)

April 11, 2023 at 3:35 pm

#4172357

Viewing 15 posts - 1,591 through 1,605 (of 59,099 total)