Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,856 through 6,870 (of 59,072 total)

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
Reply To: Calculating Previous and Next Week

It's not really a useful thing... there are 14 different "week" patterns (one for each day of the week times 2 because of leap years) and there's the issue of...
--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:23 pm

#3764227
Reply To: T-sql Syntax help needed

MiraAniston wrote:
I tried and it didn’t work for me either. Maybe you have some other solutions? Thanks
Saying something as nebulous as "it didn't work" without telling us WHAT about 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)

June 18, 2020 at 4:54 pm

#3764220
Reply To: SSMS: How to save multiple resultsets from same query into 1 result or 1 file?

VoldemarG wrote:
I am submitting an official request for DBA of certain servers to run a script on those servers and give me back the resultset.
However the script (the actual script...
--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 4:06 pm

#3764203
Reply To: How to do User Defined Function take input as text and output text and numbers ?

The MS documentation is meant to be a reference rather than a "how to use" tutorial. The key to the problem on this post is to "find the first non-numeric...
--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 3:34 pm

#3764190
Reply To: Ignoring error and continue

Phil Parkin wrote:
And the problem with your question is that you did not give me the full picture.
Now you are drip-feeding clues into the thread as they come up, which 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)

June 18, 2020 at 5:07 am

#3764090

Viewing 15 posts - 6,856 through 6,870 (of 59,072 total)