Jeff Moden

Forum Replies Created

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

Reply To: Copy DB from Prod to Test !!

Lidou123 wrote:
Yes. Indeed, the data must be protected.I will not copy anything confidential in Test environment. At the technical level, do you have any advice for copying the data 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 11, 2023 at 3:19 pm

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

rajemessage 14195 wrote:
I agree with your point, but it is needed sometimes, so please tell me is there anything wrong in first query or should I go for second one or...
--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:10 pm

#4172334
Reply To: What are some SQL commands that data scientists should be familiar with ?

Jeff Moden wrote:
Please understand that, due to the nature of your question, I believe this post is the first of one-two spam punch.
Looks like I may have been right there. 😀
--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 10, 2023 at 10:59 pm

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

Step 1... find everything in the database that will get you fired when someone steals them from your test environment and obfuscate them. You really don't want to read about...
--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 10, 2023 at 10:50 pm

#4171933
Reply To: Blocking query

SQLWizard wrote:
Still, there are a lot of opportunities to use ChatGPT, not here, of course. In terms of asking this AI language model some questions, i wouldn't say it's too...
--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 10, 2023 at 2:19 pm

#4171690
Reply To: SQL to set date/time period to 1600-1559 (dynamic)

Thom A wrote:
That (now removed) ChatGPT "solution" was amazing garbage...
I saw that post and I wish they hadn't deleted it as "spam"... it provided an excellent example of just how bad...
--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 10, 2023 at 12:32 am

#4171398
Reply To: Indexing Tables

frederico_fonseca wrote:
water490 wrote:
if this is why you do it then a index reorg is needed ONLY to cleanup the deletes and recompress the deltastores. see https://www.red-gate.com/simple-talk/databases/sql-server/performance-sql-server/hands-on-with-columnstore-indexes-part-3-maintenance-and-additional-options/ for further info
Just 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)

April 10, 2023 at 12:14 am

#4171389
Reply To: Blocking query

vsamantha35 wrote:
Jeff Moden wrote:
From the nature of some of the code, it looks like all parameters are being passed as NVARCHAR(4000).
It doesn't matter how well code may be written, that generally...
--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 9, 2023 at 1:44 am

#4171115
Reply To: Blocking query

ScottPletcher wrote:
Of course we don't know the proc parameter types, nor the column types, but I think those are critical to properly understanding whether or not SQL can properly use...
--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 9, 2023 at 1:41 am

#4171114
Reply To: Blocking query

From the nature of some of the code, it looks like all parameters are being passed as NVARCHAR(4000).
It doesn't matter how well code may be written, that generally means 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)

April 8, 2023 at 5:41 pm

#4171023
Reply To: What are some SQL commands that data scientists should be familiar with ?

Please understand that, due to the nature of your question, I believe this post is the first of one-two spam punch.
If you are not a spammer or a bot, then...
--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 8, 2023 at 5:23 pm

#4171013
Reply To: Indexing Tables

water490 wrote:
Jeff Moden wrote:
You cannot do INCLUDEs on Clustered Indexes, period. The reason why is that the Clustered Index IS the table and it already includes all the data.
I posted 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 8, 2023 at 3:13 pm

#4170978
Reply To: database schema and permissions

@lan2022nguyen ,
Thank you for the feedback.
--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 8, 2023 at 2:56 pm

#4170977
Reply To: Indexing Tables

You cannot do INCLUDEs on Clustered Indexes, period. The reason why is that the Clustered Index IS the table and it already includes all the data.
I posted a link further...
--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 8, 2023 at 4:45 am

#4170815
Reply To: Keeping Things Running

Speaking of volunteers, the Ohio North SQL Saturday (formally SQL Saturday Cleveland) by the Ohio North Data Training group (formally, a PASS group that continues because of people like Grant...
--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 8, 2023 at 3:56 am

#4170800

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