Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,971 through 8,985 (of 59,067 total)

Reply To: full text search

Sailor wrote:
Ahh, yes the table does have a full text definition. It's just not finding A00J010002158. If I do like '%A00J010002158', it finds it. But that is very slow. ...
--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)

July 22, 2019 at 3:25 pm

#3665116
Reply To: Change Character

Although I suspect it will actually be fairly rapid, there's no way to guesstimate such a thing. Create a smaller test of a couple million rows and measure. You should...
--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)

July 22, 2019 at 3:21 pm

#3665114
Reply To: Select n records in table X from a field on table Y

Ok... both of you need to read'n'heed the article at the link in my signature line below if you want help. Posting data as text doesn't help or are answering...
--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)

July 22, 2019 at 3:10 pm

#3665109
Reply To: error in dbatools

This is why I tell people to NOT rely on "OPS" (Other People's S**T)! Teach yourself how to do it using their code as an example and write your own...
--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)

July 22, 2019 at 3:07 pm

#3665108
Reply To: AVG based on condition

p.s. If you'd like to learn more about the very useful method of conditionally grouping dates by simple subtraction of an increasing number, please see the following article.
https://www.sqlservercentral.com/articles/group-islands-of-contiguous-dates-sql-spackle

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

July 22, 2019 at 2:48 pm

#3665104
Reply To: AVG based on condition

Hi Likiraght and welcome aboard!
Your question is good and so is your test data but you'll find that almost everyone likes to test their coded solutions before they post 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)

July 22, 2019 at 2:41 pm

#3665101
Reply To: XP_CMDSHELL Error

When are you getting this error? When you try to use xp_CmdShell? If so, please post the code.

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

July 22, 2019 at 12:59 pm

#3665046
Reply To: Software need db owner permission to master database (sql2016)

Desperados900 wrote:
the software is collecting measuring data for welding . the data was migrated from the manufacturer from MS-Access to MS-SQL.

Hmmm... then the only reason I can...
--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)

July 22, 2019 at 12:54 pm

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

WayneS wrote:
Jeff Moden wrote:
I also settled on "just" 32GB of RAM because 64 GB added an extra $400 to the price.
I sure wish I could pump 64GB of RAM...
--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)

July 22, 2019 at 12:40 pm

#3665041
Reply To: Are the posted questions getting worse?
Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
Has anyone had any dealings with NewEgg.com? They've got 1 heck of a deal on a laptop that I'd like to get but...
1. They are not BBB accredited.
--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)
July 22, 2019 at 12:28 pm

#3665030
Reply To: Reduce size of tempdb file mdf files

Not entirely true, Leo... I've shrunk the files for TempDB just like any other file (although the last time I did so was way back in SS 2012). Contrary 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)

July 22, 2019 at 12:17 pm

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

I've not actually had the "pleasure" of doing Windows Updates on our servers, Tom. That's a part of what our infrastructure team does. I've also not heard of any problems...
--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)

July 21, 2019 at 11:21 pm

#3664895
Reply To: Do You Have the Gifts to Be a DBA?

That's an awesome compliment, Tom. Dunning-Krugger says that I'm not sure that I deserve such an accolade, especially from you, but thank you very kindly.
I actually got out of 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)

July 21, 2019 at 10:32 pm

#3664894
Reply To: T-SQL sorting

Oooohhhh, don't get me started again, Tom. 😀
--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)

July 21, 2019 at 10:23 pm

#3664893
Reply To: Mass replace of DB codes

Do you need to preserve the order of the codes in any way, shape, or fashion? If not, you can use the String_Split() function, which has been available in SQL...
--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)

July 20, 2019 at 7:36 pm

#3664778

Viewing 15 posts - 8,971 through 8,985 (of 59,067 total)