Jeff Moden

Forum Replies Created

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

RE: Is sp_send_dbmail Asynchronous?

I think the following link may have the answers to all of this...
https://docs.microsoft.com/en-us/sql/relational-databases/database-mail/database-mail-log-and-audits?view=sql-server-2017
--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 11:15 pm

#2019904
RE: very slow select

ScottPletcher - Wednesday, January 23, 2019 11:15 AM
Jeff Moden - Wednesday, January 23, 2019 10:39 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 10:53 pm

#2019903
RE: very slow select

ScottPletcher - Wednesday, January 23, 2019 10:16 AM
No, I've looked for fragementation, and other page-size issues, and haven't seen it.
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 23, 2019 at 10:39 am

#2019847
RE: very slow select

ScottPletcher - Wednesday, January 23, 2019 7:53 AM
this is because the keys of the Clustered Index become a part of 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 23, 2019 at 9:46 am

#2019839
RE: Creating and using inline table-valued functions

kimani_m - Wednesday, January 23, 2019 7:36 AM
Thank you Jeff and also, thank you for pointing out that you can certainly 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)

January 23, 2019 at 8:00 am

#2019818
RE: How do I change a SELECT statement in a stored procedure based on the value of a variable?

Please see the following article. I consider it to be the "GO TO" article for such queries.
https://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
--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:39 am

#2019811
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

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