Jeff Moden

Forum Replies Created

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

RE: Converting Date and Time to Date

thomas.miller1 - Wednesday, January 23, 2019 7:27 AM
Lynn Pettis - Tuesday, January 22, 2019 11:07 PM
--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 23, 2019 at 7:34 am

#2019807
RE: Fiscal Column Year - Month / Values Result

angelreynosog - Wednesday, January 23, 2019 6:59 AM
Jeff Moden - Tuesday, January 22, 2019 9:30 PM
--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 23, 2019 at 7:32 am

#2019806
RE: very slow select

ScottPletcher - Tuesday, January 22, 2019 11:27 AM
Jeff Moden - Tuesday, January 22, 2019 10:57 AM
--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 23, 2019 at 7:29 am

#2019805
RE: Fiscal Column Year - Month / Values Result

Phil Parkin - Tuesday, January 22, 2019 3:32 PM
angelreynosog - Tuesday, January 22, 2019 2:23 PM
--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 22, 2019 at 9:30 pm

#2019771
RE: Converting Date and Time to Date

thomas.miller1 - Tuesday, January 22, 2019 4:43 PM
Jeffrey Williams 3188 - Tuesday, January 22, 2019 4:30 PM
--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 22, 2019 at 9:22 pm

#2019770
RE: Is sp_send_dbmail Asynchronous?

Sue_H - Tuesday, January 22, 2019 6:45 AM
Jeff Moden - Monday, January 21, 2019 11:23 PM
--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 22, 2019 at 9:15 pm

#2019769
RE: Year By Months -Columns

angelreynosog - Tuesday, January 22, 2019 10:09 AM
Hi guys
In what way can I have a result of a table that the columns...
--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 22, 2019 at 9:11 pm

#2019768
Reply To: Creating and Using Inline Table-Valued Functions

Agreed with the others. Nice job on the article, Kimani .
BTW/FYI... you CAN actually call a stored procedure from within a function using OPENROWSET. 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)

January 22, 2019 at 8:12 pm

#2019766
RE: Date functions..

Jeffrey Williams 3188 - Tuesday, January 22, 2019 12:06 PM
Jeff Moden - Tuesday, January 22, 2019 11:52...
--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 22, 2019 at 7:07 pm

#2019764
RE: Year By Months -Columns

Please don't use EOMonth. If you're trying to write criteria to isolate a month in your queries, use the standard of "SomeDate >= FirstOfMonth and SomeDate < FirstOfNextMonth". It'll work...
--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 22, 2019 at 6:48 pm

#2019763
RE: Date functions..

Sean Lange - Monday, January 21, 2019 2:49 PM
I could easily put together a test in a VS project but 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)

January 22, 2019 at 11:52 am

#2019701
RE: View timeout problem

Bruce-12445 - Monday, January 21, 2019 11:16 PM
thanks Jeff the OPENQUERY solution solved all discrepancies.
Thanks for the feedback, Bruce.
--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 22, 2019 at 11:03 am

#2019690
RE: Versatile or Jack of all trades

djackson 22568 - Tuesday, January 22, 2019 7:48 AM
Jeff Moden - Monday, January 21, 2019 3:09 PM
--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 22, 2019 at 11:02 am

#2019688
RE: very slow select

ScottPletcher - Tuesday, January 22, 2019 10:02 AM
You wouldn't typically want to cluster on status, since it tends to change.
However, you'd almost...
--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 22, 2019 at 10:57 am

#2019687
RE: Ways to search Faster In Ms SQL Server

First, learn how to use all of the built-in functions of SQL Server/T-SQL because, as with any language, that's where a lot of the performance is.
Second, read 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)

January 22, 2019 at 12:19 am

#2019594

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