Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,221 through 5,235 (of 59,101 total)

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
Reply To: create html email

Shifting gears a bit, here' a search that will lead you to many different fairly easy methods of doing simple things in HTML from T-SQL.
https://duckduckgo.com/?q=create+html+table+in+t-sql&ia=web
You can easily get 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 30, 2021 at 12:32 am

#3889746
Reply To: SQL SUM and divide linked tables

There doesn't appear to be any information in any of the tables that associates a given CarID with an invoice. The closest thing to that is the InvoicesCostCenterAllocations table but...
--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 28, 2021 at 8:49 pm

#3889390
Reply To: create html email

Jeffrey Williams is spot-on with his post above. I'll add that you should post the example data in a "Readily Consumable Format". Please see the article at the first link...
--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 28, 2021 at 7:17 pm

#3889361

Viewing 15 posts - 5,221 through 5,235 (of 59,101 total)