Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,841 through 6,855 (of 59,091 total)

Reply To: XML parsing/shredding

Is there more than one "Address" element per XML or is there always just 1 (regardless of how many attributes that node contains)?

--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)

July 4, 2020 at 6:00 pm

#3767508
Reply To: Temporal Table Reporting

Leighton21 wrote:
Only the temporal tables. So one would be customer and another would be customer address. The report would show the transactions against each chronologically for example
Username, EventDate, Table, NewValue,...
--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)

July 4, 2020 at 5:50 pm

#3767507
Reply To: Beginner needing help

Lordy, Joe. The OP didn't design any of this. It's cut'n'paste from homework or a test.
Also, the stuff about the "1960s pointer chains is not relational"... that's a load 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)

July 4, 2020 at 5:29 pm

#3767505
Reply To: Beginner needing help

This is either homework or a test of some kind. At least TRY to do something on your own, post it, and if you have a question you can't answer...
--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)

July 4, 2020 at 3:38 pm

#3767490
Reply To: Your Best Day

Heh... getting a little older and being prone to affib has changed what I call my "best day". My "best day" is always TODAY. It means that I woke up...
--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)

July 4, 2020 at 3:24 pm

#3767489
Reply To: Unusual use of the WHERE clause

michael.leach2015 wrote:
I am working an exercise problem where the solution provided has a WHERE clause used in a way I have not seen before. The question asks, "to show 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)

July 4, 2020 at 2:40 pm

#3767486
Reply To: Same Query to run in different DB.

I agree with the notion of a view that dkultasev posted. If these types of changes are infrequent, then manually building one would be fine. If these tables change 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)

July 4, 2020 at 1:59 pm

#3767467
Reply To: Adding NOT NULL to column with existing rows causes page bloat

It would be helpful if you posted the CREATE TABLE statement for the table both before and after each change you make to the table. Also, the devil's in 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)

July 4, 2020 at 1:53 pm

#3767466
Reply To: stored procedure to delete user and login

It would be real helpful if you were to describe what you mean by "it does not work". What isn't it doing and what, if any, are the error messages?
Also,...
--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)

July 4, 2020 at 1:30 pm

#3767463
Reply To: Query taking more than 4 hrs. - Any recommendations/suggestions?

Feivel wrote:
Jeff Moden wrote:
See the 2nd link in my signature line below on the information you should provide on performance related problems. Thanks.
Okay thanks I'll follow this guideline going forward. Could...
--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)

July 4, 2020 at 2:00 am

#3767433
Reply To: TempDB question help and best practices to implement

JSB_89 wrote:
@jeff
Developers think its always DBA's fault bcz the query is running slow . Initially they were pulling data to temp tables which we corrected into physical tables and drop...
--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)

July 3, 2020 at 12:15 am

#3767194
Reply To: Query taking more than 4 hrs. - Any recommendations/suggestions?

See the 2nd link in my signature line below on the information you should provide on performance related problems. Thanks.
--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)

July 2, 2020 at 5:04 pm

#3767089
Reply To: TempDB question help and best practices to implement

JSB_89 wrote:
Our developers are running a huge select query pulling millions of records for a datawarehouse and when examined the query shown no issues in the Executionplan .
Heh... you've correctly...
--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)

July 2, 2020 at 4:58 pm

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

@as1981 ,
Apologies for missing your question on this.
Yes, it's possible to work it out from historical information as you've said but it's still pretty much of a SWAG simply because...
--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)

July 1, 2020 at 7:47 pm

#3766820
Reply To: SQL Server Trigger to prevent insertion of duplicate data in Table

I don't know if it will help in this case but you CAN write a unique index with an "Ignore Duplicates" attribute that will simply not insert duplicates and won't...
--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 30, 2020 at 8:49 pm

#3766558

Viewing 15 posts - 6,841 through 6,855 (of 59,091 total)