Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,331 through 9,345 (of 59,099 total)

Reply To: Delete is very slow

Guras wrote:
Thank you I will try this.

You really need to answer the questions about how many indexes there are. You'll also need to identify how many foreign keys there are. ...
--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)

May 11, 2019 at 8:02 pm

#3640633
Reply To: NOT IN with OpenRowSet

TJ_T wrote:
This almost works: WHERE ModelName0 NOT IN ( SELECT value FROM String_Split(@Job_numbers, ',') ) But when you run the query it builds a list, but after the first row...
--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)

May 11, 2019 at 7:56 pm

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

frederico_fonseca wrote:
Grant Fritchey wrote:
Thom A wrote:
In other news, what do you do when 2 CLI languages for your OS's isn't enough: Introduce a third: https://devblogs.microsoft.com/commandline/introducing-windows-terminal/ I admit I haven't read too far...
--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)

May 11, 2019 at 3:42 pm

#3640496
Reply To: General SQL Development Question.

koti.raavi wrote:
Jeff - Destination is unknown, we just need to place file in network location in specific format requested by destination team.
There could be a serious advantage in doing this...
--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)

May 11, 2019 at 1:44 pm

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

jasona.work wrote:
Jeff Moden wrote:
Just to be sure, are you talking about Columbus or Pittsburgh? I'm assuming "Columbus" because i don't believe Pittsburgh has announced yet.
Columbus, Pittsburgh would be 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)

May 10, 2019 at 11:07 pm

#3640199
Reply To: Monitor network traffic

Chitown wrote:
Is there a way to monitor network bandwidth on a SQL Server? My network admin is telling me that we r using over 1 terabyte of bandwidth per hour...
--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)

May 10, 2019 at 4:18 pm

#3639994
Reply To: User notices on SSMS

EamonSQL wrote:
Hi, I manage a server and would like to know is there a way of placing a small message that sits in view of all users connected to 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)

May 10, 2019 at 4:12 pm

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

jasona.work wrote:
Well that's just DUCKY!
Is that a good thing, a bad thing, or are you just "quackin' up"? 😀

jasona.work wrote:
Signed up (hotel and everything!) for this SQL Saturday, 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)

May 10, 2019 at 1:14 pm

#3639849
Reply To: General SQL Development Question.

It's known as an "Upsert" or a "Merge".

What IS the final destination here?
--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)

May 10, 2019 at 1:10 pm

#3639847
Reply To: how to find which persion have all colorcodes using color table in sql server

John Mitchell-245523 wrote:
What indexes do you have on the tables? Please post an actual execution plan for the query (the .sqlplan file, not just a picture, please). John
Great suggestion that worked very...
--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)

May 10, 2019 at 1:07 pm

#3639846
Reply To: NOT IN with OpenRowSet

TJ_T wrote:
Hi, I am trying to use a text file to exclude a list of things.

WHY a text file? Without additional information here, I don't see the merit 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)

May 10, 2019 at 1:04 pm

#3639845
Reply To: about T-SQL Scripts tuning

892717952 wrote:
1. when I create an index in a table or views, is there any good way to konw (or evaluate) the index is necessary and correct?
Yes. It...
--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)

May 10, 2019 at 12:44 pm

#3639829
Reply To: Converting Substring to DateTime - extra eyes please

Thanks, ZZ. What you wrote have been my findings, as well. I'm amazed the MS hasn't made PowerShell easier to use from SQL Server. I'm also amazed that they have...
--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)

May 10, 2019 at 12:22 pm

#3639812
Reply To: Tasks of Senior SQL Server Experts/Data Scientists
The four biggees (there are certainly more) that I can think of are...
1. Practice doing restores and setup something to do restores "under the gun" for when something goes 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)
May 9, 2019 at 1:47 pm

#3639059
Reply To: Delimited Identifiers in code interpreted as BBCode

Thom A wrote:
Jeff Moden wrote:
I'm hoping that's not actually a bad thing. 😉
Being able to turn the software off that's trying to keep your work device "safe" doesn't seem "safe". ;)...
--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)

May 9, 2019 at 1:19 pm

#3639023

Viewing 15 posts - 9,331 through 9,345 (of 59,099 total)