Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,276 through 13,290 (of 59,101 total)

RE: rounding up to the next whole number

Thanks for the feedback. Also consider the ROUND function. Use of the normally missed 3rd parameter can help solve certain problems.
https://docs.microsoft.com/en-us/sql/t-sql/functions/round-transact-sql
--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 2, 2018 at 2:39 pm

#1974134
RE: An Introduction to PowerShell for a DBA

Alex Chamchourine - Tuesday, January 2, 2018 11:53 AM
Where SSIS supposedly shines? It's a very well structured things by its very...
--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 2, 2018 at 2:35 pm

#1974133
RE: An Introduction to PowerShell for a DBA

Alex Chamchourine - Tuesday, January 2, 2018 12:13 PM
Hi Jeff. You provided a very interesting and thorough example. You definitely should...
--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 2, 2018 at 2:31 pm

#1974132
RE: Convert SQL results into single row of data

paul.stevens 24552 - Tuesday, January 2, 2018 7:15 AM
Hi All, Thanks for the advice. Got it sorted using a PIVOT and cross...
--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 2, 2018 at 7:57 am

#1974060
RE: Splitting TempDB across multiple files

GilaMonster - Tuesday, January 2, 2018 6:59 AM
Jeff Moden - Tuesday, January 2, 2018 6:19 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 2, 2018 at 7:12 am

#1974056
RE: Splitting TempDB across multiple files

Perry Whittle - Tuesday, January 2, 2018 5:12 AM
Tava - Wednesday, December 27, 2017 6:38 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 2, 2018 at 6:19 am

#1974050
RE: An Introduction to PowerShell for a DBA

kevaburg - Tuesday, January 2, 2018 12:37 AM
To be honest I would love to see your answer written as an article 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 2, 2018 at 6:01 am

#1974048
RE: Understanding Your Value

BWAAA-HAAAA!!!! I wonder how many people that respond to the survey know how to get the current date and time in SQL Server. 😉
--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 1, 2018 at 11:30 pm

#1974014
RE: An Introduction to PowerShell for a DBA

kevaburg - Sunday, December 31, 2017 7:55 AM
Jeff Moden - Saturday, December 30, 2017 6:47 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 1, 2018 at 11:15 pm

#1974013
RE: An Introduction to PowerShell for a DBA

kevaburg - Saturday, December 30, 2017 1:52 AM
Jeff Moden - Friday, December 29, 2017 7:51 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)

December 30, 2017 at 6:47 pm

#1973990
RE: BULK INSERT ERROR

shaikwaseem888 - Saturday, December 30, 2017 3:24 PM
Dear Friends,
i am new in this forum and i hope that i will get 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)

December 30, 2017 at 3:41 pm

#1973989
RE: Happy New Year 2018

I'm going to leave all aspects of work, bug fixes, moving to better hardware, upgrades, etc, etc, out of this and simply say, Mr. Jones, thank you for what you...
--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)

December 30, 2017 at 3:20 pm

#1973987
RE: How to convert kilograms to pounds and ounces

TomThomson - Saturday, December 30, 2017 4:50 AM
Jeff Moden - Friday, December 29, 2017 7:35 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)

December 30, 2017 at 6:36 am

#1973940
RE: Index Fragmentation

jarmendadmin - Monday, December 4, 2017 6:11 PM
Jeff Moden - Monday, December 4, 2017 4: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)

December 29, 2017 at 10:00 pm

#1973928
RE: An Introduction to PowerShell for a DBA

Alex Chamchourine - Friday, December 29, 2017 11:48 AM
Hmmm.... they're overdue... I wonder when they're going to throw SSIS on...
--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)

December 29, 2017 at 7:51 pm

#1973927

Viewing 15 posts - 13,276 through 13,290 (of 59,101 total)