Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,886 through 6,900 (of 59,102 total)

Reply To: SSC Traffic Declining ?

Steve Jones - SSC Editor wrote:
A mix of things. Traffic has declined lately, which is weird.
We depend a log on Google, so we are competing with SO and other places in that sense. Part...
--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 22, 2020 at 3:52 pm

#3764685
Reply To: My Left Join is NOT working - RESOLVED!!!

Try moving everything in the WHERE clause to the ON clause.
--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 22, 2020 at 3:46 pm

#3764684
Reply To: Error creating AWS RDS Linked Server to Oracle

You're paying a lot of money for AWS RDS. Unfortunately, it also means that you give up some things because AWS is managing the instance for you. For example, if...
--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 22, 2020 at 3:40 pm

#3764682
Reply To: Storing VARCHAR(MAX) off-row

Have you verified that the out of row setting on the table is actually active?

--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 22, 2020 at 3:33 pm

#3764679
Reply To: Get 2 decimals in my query

I sure am happy to see that I'm not the only one that thinks the contributors that seriously helped make this forum great have taken it in the socks in...
--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 22, 2020 at 3:30 pm

#3764678
Reply To: Get 2 decimals in my query

Thom A wrote:
saravanatn - Tuesday, July 24, 2018 2:02 AM
GG_BI_GG - Tuesday, July 24, 2018 12:58 AM
Product Table look like in...
--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 22, 2020 at 2:07 pm

#3764664
Reply To: Project EVERYTHING is assigned to me. Can I measure Everything via T-SQL? How?

VoldemarG wrote:
Jeff,
Re: sp_ShowWorst
Question: will collecting rows from SYSTEM DBs (i see a lot from msdb, master...) be beneficial to me in any way?
i am thinking to easily modify/limit it 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 22, 2020 at 2:03 pm

#3764663
Reply To: Storing VARCHAR(MAX) off-row

John Mitchell-245523 wrote:
Changing the option only applies for new rows. The rows that were in the table before you changed the option will stay where they were. Could that be what'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 22, 2020 at 1:58 pm

#3764661
Reply To: Temporal Table Reporting

What I'm concerned about is that it appears that it sounded like you have several temporal tables but management was asking you for any and all changes to every table. ...
--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 22, 2020 at 6:55 am

#3764627
Reply To: Reliable practice tests and exam dumps for exam 70-761 (T-SQL Queries)

Heh... exam dumps and other cheater methods (and that's what they are to me)... This is one of the primary reasons why (except for the MCM certification, which they no...
--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 21, 2020 at 6:49 pm

#3764601
Reply To: Temporal Table Reporting

First things first... has management approved the purchase of at least 10 times the amount of disk space you'll need to store just the next year's worth of changes? 😉

--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 21, 2020 at 5:43 pm

#3764591
Reply To: The Future Direction of the PASS Organization

Ok, so let's just say that PASS, as an organization, disappeared (and I hope it doesn't). Who would take the responsibility for the SQLSaturday site? Who would fund the box...
--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 19, 2020 at 4:00 pm

#3764408
Reply To: Project EVERYTHING is assigned to me. Can I measure Everything via T-SQL? How?

VoldemarG wrote:
<<< https://www.sql.ru/forum/96127/sp-who3%5B/quote%5DMsg 8152, Level 16, State 13, Line 1
String or binary data would be truncated.
DBCC execution completed. If DBCC printed error messages, >>. Jeff, what parameters did you call...
--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 19, 2020 at 2:07 pm

#3764373
Reply To: Project EVERYTHING is assigned to me. Can I measure Everything via T-SQL? How?

VoldemarG wrote:
Sure, found it, thank you. I know, my habit to laziness caused me to ask a simple question I should not have been asking... yet there is a variation...
--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 19, 2020 at 1:45 am

#3764296
Reply To: Project EVERYTHING is assigned to me. Can I measure Everything via T-SQL? How?

With the idea of teaching a man to fish, lookup each of the DMVs that sp_ShowWorst calls upon in the MS documention and look for the "Permissions" section.
You might already...
--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 18, 2020 at 5:51 pm

#3764232

Viewing 15 posts - 6,886 through 6,900 (of 59,102 total)