Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,206 through 5,220 (of 59,089 total)

Reply To: SQL Subqueries
Never mind. I'll just assume that ties for first need to be displayed.
```
    WITH cteCount AS
(--==== Do the math, which seriously reduces the rowcount...
```
--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)
June 2, 2021 at 2:12 am

#3890808
Reply To: SQL Subqueries

beefycarrot wrote:
Hi ! i got a task where i am to post only the Reshnum of the Department with the highest count of admissions. there are two tables relevant 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)

June 2, 2021 at 1:02 am

#3890804
Reply To: Automate restore

You have been working with SQL Server for at least 12 years and 8 months according to your profile. With that, you should know what I'm going to say... it's...
--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)

June 2, 2021 at 12:11 am

#3890789
Reply To: A Computer on Wheels

Steve Jones - SSC Editor wrote:
I like the Dog Mode having a big sign on the display and the temp setting. We'd certainly use that with our pups.
I'm torn with a lot 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)

June 1, 2021 at 6:12 pm

#3890654
Reply To: A Computer on Wheels

Eric M Russell wrote:
That "dog mode" feature is interesting, but even then I don't think it will necessarily prevent your vehicle from attracting unnecessary attention. I have tethered my dog 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)

June 1, 2021 at 2:44 pm

#3890594
Reply To: add another check for update

I just don't know enough about the data nor what the rules being following for which prices to use are. I also suggested that you'll need to add the extra...
--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)

June 1, 2021 at 2:21 pm

#3890569
Reply To: add another check for update

Bruin wrote:
Yes sorry typo when I pasted.
and d.Prod_Line in ('xx87;)
Any help on how I and where I add the extra criteria?
Thanks.
My question is ... is that the only error 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)

May 31, 2021 at 6:58 pm

#3890292
Reply To: SQL SERVER CLUSTERING INTERVIEW QUESTIONS

rehvin wrote:
Hi guys, I have found this resource for interview preparation https://artoftesting.com/sql-queries-for-interview
Lordy... not another one... 🙁 Jumping straight to the final two questions in the "experienced" section...
Without loading it into...
--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 31, 2021 at 5:15 pm

#3890277
Reply To: Generate DDL-Script based on Meta-Data

It'll be interesting when someone realizes the mistake they made my omitting the parentheses from the "decimal" notations and either includes them in the future or decides to remove them...
--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 31, 2021 at 12:49 am

#3890042
Reply To: A Computer on Wheels

To be honest, I'd love to go back to the good ol' days where the closest thing to a computer in a car was intermittent wipers and cruise control. 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 31, 2021 at 12:26 am

#3890037
Reply To: Factless fact to resolve business requirements or other design approach?

Like Granny used to say, "Mind the pennies and the dollars will take care of themselves". 😀
In this case, I'd concentrate on the tables that need to be PITted. 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)

May 31, 2021 at 12:13 am

#3890036
Reply To: Unused Databases, Last accessed DB
francesco.mantovani wrote:
If the last_access column is null then no reads or writes have occurred:
```
WITH cte AS (
SELECT database_id, dt, op 
FROM sys.dm_db_index_usage_stats
UNPIVOT (dt for op in (last_user_lookup,...
```
--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 30, 2021 at 11:54 pm

#3890032
Reply To: Speed up join

Scott745618 wrote:
The table does not have an index that I can use to speed up the join
This is why I previously posted what I did. There are sometimes "tricks" 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)

May 30, 2021 at 11:42 pm

#3890030
Reply To: Factless fact to resolve business requirements or other design approach?

I suppose you could use a Factless Fact Table as a "bridge" or "join" table for this type of thing but what I recommend is paying real close attention 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)

May 30, 2021 at 11:25 pm

#3890019
Reply To: add another check for update

You do realize that you're missing a single-quote in that, right?
--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 30, 2021 at 4:44 pm

#3889948

Viewing 15 posts - 5,206 through 5,220 (of 59,089 total)