Jeff Moden

Forum Replies Created

Viewing 15 posts - 976 through 990 (of 59,063 total)

Reply To: How do I add files to the server?

Mr. Brian Gale wrote:
While I agree with Jeff in the sense that "if the system is designed in one way, why change it to work a different way", I think I would...
--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)

October 27, 2023 at 9:09 pm

#4316215
Reply To: How do I add files to the server?

To add another 2 cents, I totally agree with David Wiseman. Storing the full path instead of just a file name can be a horrible idea for the very reasons...
--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)

October 27, 2023 at 8:48 pm

#4316214
Reply To: What happens when an online index rebuild (not resumable) is cancelled?

The only time that I've used ONLINE Index Rebuild was during testing on some test tables. I've never tested for a "cancel" of an ONLINE Rebuild like you folks accidentally...
--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)

October 27, 2023 at 2:31 am

#4315703
Reply To: The Column Synonym

Jeffrey Williams wrote:
Jeff Moden wrote:
Jeffrey Williams wrote:
Imagine a view is created - that references a computed column which only exists to give the column a different name - and aliases the computed column...
--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)

October 26, 2023 at 9:40 pm

#4315566
Reply To: How do I add files to the server?

I'll likely be alone on my take on this but "It Depends" on a whole lot of things.
When I first started at a company that I do work for, they...
--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)

October 26, 2023 at 9:12 pm

#4315552
Reply To: Is SQL Search 3 still supported?

Heh... not bad for something that used to be natively available on the f4 key until they came out with SQL Server 2005. 🙁 What a bummer that was (and...
--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)

October 26, 2023 at 7:43 pm

#4315507
Reply To: Will ALTER TABLE modify a column with the same type or skip it?

Have you considered just making a large test table and testing 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)

October 26, 2023 at 5:48 pm

#4315467
Reply To: Query related issue

As a bit of a sidebar, I've not found any performance improvement that I can relate to the "new" CE but have a whole bunch of slowdowns that I can...
--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)

October 26, 2023 at 5:45 pm

#4315464
Reply To: The Column Synonym

Jeffrey Williams wrote:
You can also add a computed column to the table - but I really don't see the need or requirement to create a column with multiple names. It 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)

October 26, 2023 at 12:38 am

#4314969
Reply To: Searching in date field provides inconsistent results

jcelko212 32090 wrote:
Your singular table name indicate you have only one Rate.
Not if you understand that each row is unique and can have only one rate. Either convention is just...
--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)

October 25, 2023 at 9:25 pm

#4314892
Reply To: How to find ultimate parent

inayatkhan wrote:
Hi
I have dataset like this
drop table if exists #dataset create table #dataset(CIF VARCHAR(255), PARENT_CIF VARCHAR(255), UP_CIF VARCHAR(255))
INSERT INTO #dataset SELECT 45218547, 54044082, 54044082 union all SELECT 54044082, 64349595, 64349595...
--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)

October 25, 2023 at 9:18 pm

#4314891
Reply To: What Exactly Is a CTE in T-SQL? A Comprehensive Guide with 7 Examples

YSLGuru wrote:
I thought Elvis was dead.
😀
--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)

October 24, 2023 at 11:03 pm

#4314250
Reply To: What Exactly Is a CTE in T-SQL? A Comprehensive Guide with 7 Examples

It would appear that the author of the article has left the building. 🙁
--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)

October 24, 2023 at 6:25 pm

#4314087
Reply To: What Exactly Is a CTE in T-SQL? A Comprehensive Guide with 7 Examples

Jeffrey Williams wrote:
This isn't quite correct - neither CTEs or Views are executed (materialized). Both will be incorporated into the outer query - and then the execution plan is generated.
Now, 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)

October 24, 2023 at 6:22 pm

#4314086
Reply To: What Exactly Is a CTE in T-SQL? A Comprehensive Guide with 7 Examples

YSLGuru wrote:
Glad to see Jeff is here, I know he'll have some interesting insight onnthis question. CTE or View, which to use and when as well as why?
Thank you for...
--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)

October 24, 2023 at 1:07 am

#4313692

Viewing 15 posts - 976 through 990 (of 59,063 total)