Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,191 through 5,205 (of 59,072 total)

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
Reply To: Working Predictable Hours

JRuss wrote:
Reported in The Economist just last week: "Working 55 hours or more a week is 'a serious health hazard' according to the World Health Organisation, in a first global...
--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:08 pm

#3889359
Reply To: Speed up join

@scott745618,
I suspect that there's some pretty nasty accidental many-to-many joins based on the account number and date. Take a look at the article at the 2nd link in my signature...
--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 1:52 pm

#3889229
Reply To: How much will it cost or save to rebuild that index? (SQL Oolie)

Rasmus Remmer Bielidt wrote:
I realise that I am a bit late to the party. The percentage increase is one that many people get wrong.
When I demonstrate similar issues, I like to use...
--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 12:54 pm

#3889196
Reply To: Query never completes on HAG primary replica but runs in seconds on Secondary

I'll go one step further... stop using REORGANIZE except to compress LOBs and then make sure that you do a REBUILD right after because it also compresses the indexes. 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 28, 2021 at 12:15 am

#3888992

Viewing 15 posts - 5,191 through 5,205 (of 59,072 total)