Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,191 through 17,205 (of 59,067 total)

RE: Auto Email based on rule - Is it possible?

wrightyrx7 (7/20/2016)
Hi all,
Just getting to know SQL Server and found information all over Google relating to sending emails via SQL Server.
However, what i would like is a scheduled email that...
--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 20, 2016 at 9:13 pm

#1891200
RE: Substring from RIGHT

Smendle (7/20/2016)
Jeff Moden (3/4/2016)
John Mitchell-245523 (3/4/2016)
REVERSE the string, use SUBSTRING, and then REVERSE it again.
John
Got code?
Something like this?
With MyCTE(val)
AS
(
SELECT '9.0.0832.1032' UNION ALL --need to get the 32 (one after 08)....
--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 20, 2016 at 8:48 pm

#1891199
RE: Identical Query, Different Execution Stats

Shifting gears a bit, I've recently come across a similar post. Setting trace flag 1118 apparently worked a miracle. I forget about such things because I've had that...
--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 20, 2016 at 8:37 pm

#1891198
RE: Correct MAXDOP setting

smthembu (7/19/2016)
I hear you but my problem is that I did mention to powers that be but it has fallen to deaf ears, I have to make mini cooper pull...
--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 20, 2016 at 8:32 pm

#1891197
RE: Cluster Index change on a table with 1 billion rows

Shifting gears, I've found that compression generally causes the queries that we use to be twice as slow. Not worth it for me even for the legacy data, which...
--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 20, 2016 at 8:25 pm

#1891196
RE: Cluster Index change on a table with 1 billion rows

If you do an explicit DROP INDEX, then yes... it will cycle through a heap stage, which will cause all of the NCIs to rebuild and point at the heap....
--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 20, 2016 at 8:20 pm

#1891195
RE: Cluster Index change on a table with 1 billion rows

sql-lover (7/20/2016)
GilaMonster (7/20/2016)
sql-lover (7/20/2016)
Does above command will still apply if the new cluster index is different than the original one? Let's say... existing Index is on col1, col2. New...
--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 20, 2016 at 5:54 pm

#1891190
RE: Cluster Index change on a table with 1 billion rows

sql-lover (7/20/2016)
We need to change the cluster index definition on a table with 1 billion rows. This will be performed on SQL2016 Enterprise edition.
Initially , I wanted to do this...
--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 20, 2016 at 12:37 pm

#1891123
RE: Substring from RIGHT

John Mitchell-245523 (7/20/2016)
Jeff Moden (3/4/2016)
John Mitchell-245523 (3/4/2016)
REVERSE the string, use SUBSTRING, and then REVERSE it again.
John
Got code?
(Didn't see this response when it was posted.)
No, I haven't. I've suggested 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)

July 20, 2016 at 11:43 am

#1891118
RE: Script to stop service using XP_CMDSHELL, restore full and differential .bak files in a single script

lsalih (7/19/2016)
Phil -
You are correct, initially I was trying to print the error message if there was an error. I appreciate correcting me, and I have added throw vs using...
--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 19, 2016 at 8:23 pm

#1890990
RE: Correct MAXDOP setting

TheSQLGuru (7/19/2016)
Jeff Moden (7/19/2016)
smthembu (7/19/2016)
@Gail, what else to look for?
Can't speak for Gail but my suggestion would be... a small amount of money to at least quadruple memory or spend...
--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 19, 2016 at 8:09 pm

#1890988
RE: Correct MAXDOP setting

smthembu (7/19/2016)
@Gail, what else to look for?
Can't speak for Gail but my suggestion would be... a small amount of money to at least quadruple memory or spend some time fixing...
--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 19, 2016 at 7:46 pm

#1890983
RE: Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators

CELKO (7/19/2016)
Maybe I missed the question, but SQL/PSM is how the ANSI/ISO standards handle procedures and functions. Also triggers, God help us.
As an aside, the "parameter versus argument"...
--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 19, 2016 at 7:36 pm

#1890981
RE: Script to stop service using XP_CMDSHELL, restore full and differential .bak files in a single script

Never mind. Post removed.
--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 19, 2016 at 7:19 pm

#1890978
RE: how to set NULLs to Zero

ocean3300 (7/19/2016)
If you want to display sum(omlExtendedPriceBase) as 0 if the value is null, use ISNULL(SUM(omlExtendedPriceBase),0).
That's one of the many reasons why I don't use PIVOT. A good ol'...
--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 19, 2016 at 6:59 pm

#1890977

Viewing 15 posts - 17,191 through 17,205 (of 59,067 total)