Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,691 through 6,705 (of 59,102 total)

Reply To: get top 5 max count for each month
michaelyarbrough1975 wrote:
I changed the order by and it returned 12 records for the 1st month. I'm expecting 5 records for each month. Thank you.
```
SELECT DISTINCT t.Company,sales.[Month], sales.Sales
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)
August 2, 2020 at 1:22 am

#3776614
Reply To: Trying to find all databases not in using sys.dm_db_index_usage_stats

Heh... serendipity strikes. There's a pretty good article on all of this that was in an article in yesterday's MSSQLTips email. The link to the article I'm talking about 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)

August 2, 2020 at 1:16 am

#3776613
Reply To: string compare again .. :)

My apologies... I missed the part about the "array position" in your original post. We can fix that but Split_String isn't going to work at all for that because (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)

August 2, 2020 at 1:03 am

#3776612
Reply To: Run same query on multiple servers with sqlcmd and save the output

x wrote:
Jeff Moden wrote:
Steve Jones - SSC Editor wrote:
Yes, the login isn't correct. That's what the error is.
salliven wrote:
But I didn't change the login parameters. So I don't know why is working the 1st case...
--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)

August 1, 2020 at 8:34 pm

#3776592
Reply To: Trying to find all databases not in using sys.dm_db_index_usage_stats

Lowell wrote:
sys.dm_db_index_usage_stats already has all the index usage for all databases and all tables inside it..
Careful now. If, for example, any database is totally unused, it my not show up...
--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)

August 1, 2020 at 8:16 pm

#3776591
Reply To: string compare again .. :)

p.p.s.
If anyone wants to do some testing of the method I posted or some other method, here's a 500,000 row test table like the OP said ("few hundred thousand") they...
--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)

August 1, 2020 at 7:04 pm

#3776586
Reply To: string compare again .. :)

p.s.
If you have to do such lookups a whole lot, it would help a whole lot if you materialized the NVP as a very narrow unique Clustered Index table 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)

August 1, 2020 at 6:26 pm

#3776562
Reply To: string compare again .. :)

Ok... making the assumption that ID1 is actually supposed to be unique, here's the creation/population of the test table that I reformatted the way I normally would write such 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)

August 1, 2020 at 6:02 pm

#3776561
Reply To: string compare again .. :)

Did you mean to have 2 entries in the StrHold table that have a "6" for ID1 or is that a typo???
--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)

August 1, 2020 at 5:24 pm

#3776558
Reply To: Longest Common Substring in an ITVF

I'm not seeing any code attached to your last post. What code are you talking about being "attached"?
--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 31, 2020 at 11:41 pm

#3776459
Reply To: Ola Hallengren backup has a bug

Have you actually looked at the code in Ola's script to see what the issue may be? It could be easier to fix your problem in his code than 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)

July 31, 2020 at 11:04 pm

#3776456
Reply To: How to calculate a column recursively ?

jcelko212 32090 wrote:
I have a data as below.
Why did you fail to post any DDL? But more than that, why do you think that SQL and the relational model use any...
--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 31, 2020 at 10:57 pm

#3776451
Reply To: Run same query on multiple servers with sqlcmd and save the output

Steve Jones - SSC Editor wrote:
Yes, the login isn't correct. That's what the error is.
salliven wrote:
But I didn't change the login parameters. So I don't know why is working the 1st case and why...
--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 31, 2020 at 2:28 pm

#3776310
Reply To: Run same query on multiple servers with sqlcmd and save the output

x wrote:
reminds me of a story from one of my favorite books, a truly geeky must read in my opinion, "the soul of a new machine" by tracy kidder. they're...
--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 31, 2020 at 2:21 pm

#3776307
Reply To: Update all the sequence number of "Restart sequence" with the Current Value

Check out the following for what you can do with ALTER SEQUENCE.
https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-sequence-transact-sql?view=sql-server-ver15
Admittedly, their examples on that page suck. What you're looking for is the example that uses the RESTART...
--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 31, 2020 at 1:40 pm

#3776292

Viewing 15 posts - 6,691 through 6,705 (of 59,102 total)