Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,691 through 21,705 (of 59,098 total)

RE: "Out of Memory" Querying MySQL from MSSQL Linked Server

Have you tried nesting the select in another query that has the ORDER BY?
--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)

January 28, 2015 at 3:30 pm

#1773834
RE: Lead/Lag Functions

There's a fundamental flaw in thinking this out on the part of the client. There's a whole lot that can happen in the 1 second that ends up missing...
--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)

January 28, 2015 at 3:23 pm

#1773833
RE: All Monday date of each month.

Excellent tweak, Eirikur! :w00t:
--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)

January 28, 2015 at 8:19 am

#1773705
RE: Please explain what this Trigger query does

You bet, David. Thank you for the feedback.
--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)

January 28, 2015 at 7:21 am

#1773678
RE: Please explain what this Trigger query does

Take your time. It's 1:15AM here. I'm going to bed.:-D
--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)

January 27, 2015 at 11:15 pm

#1773571
RE: Truncate vs Delete

Yes, both can but do a simple test to prove it to yourself.
--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)

January 27, 2015 at 11:09 pm

#1773569
RE: Please explain what this Trigger query does

lawlietdba (1/27/2015)
Hi Jeff,
Please explain how to create a Reporting view for Auditing using Employee table and Employee Audit Table.
Thanks
See what I just wrote above. The best way 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)

January 27, 2015 at 10:15 pm

#1773564
RE: Please explain what this Trigger query does

David Burrows (1/26/2015)
Well done Jeff 🙂
Please clarify
You are auditing 'what was' and not 'what is'
'Insert' is the first audit row or the main row if no audit exists
and this needs...
--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)

January 27, 2015 at 10:10 pm

#1773563
RE: Please explain what this Trigger query does

lawlietdba (1/27/2015)
David Burrows (1/26/2015)
If a row is inserted and then deleted the audit view needs to duplicate the audit row if insert and delete is required to be shown separately.
Hi...
--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)

January 27, 2015 at 9:51 pm

#1773560
RE: Calendar Table Function

RunnerIE (1/7/2015)
I'm still SS2005 - The icing on the cake would be to see the ISO week calculated as well,
Please see the following article for an easy formula to incorporate.
http://www.sqlservercentral.com/articles/T-SQL/97910/
--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)

January 27, 2015 at 8:12 pm

#1773548
RE: Calculate quarters and year between two dates

Michael L John (1/27/2015)
Instead of calculating them, try this table,
http://www.sqlservercentral.com/scripts/Date/68389/
What would really be interesting is to find out is, out of all the columns that people put into their calendar...
--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)

January 27, 2015 at 8:02 pm

#1773547
RE: All Monday date of each month.

farooq.hbs (1/23/2015)
Hi,
[font="Arial Black"]How to retrieve only Monday dates from each month in sql server.
[/font]If i pass any value (Let say GETDATE()) then i should get all monday values from 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)

January 27, 2015 at 7:19 pm

#1773546
RE: All Monday date of each month.

ChrisM@Work (1/27/2015)
Gosh :blush: thanks Koen! I like what Jeff's done with it.
All I did was tweak it. It was your idea and it was (IS) a hell of 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)

January 27, 2015 at 6:43 pm

#1773542
RE: Grant Fritchey Reviews Minion Reindex

Good stuff, Sean & Jen. Thanks for taking the time to hammer that out for us.
--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)

January 27, 2015 at 3:54 pm

#1773527
RE: Grant Fritchey Reviews Minion Reindex

Sorry about the SLA question. I know it's for free and didn't check things out to see if there was a paid support option. It's one of those...
--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)

January 27, 2015 at 12:07 pm

#1773467

Viewing 15 posts - 21,691 through 21,705 (of 59,098 total)