Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,761 through 11,775 (of 59,095 total)

RE: Throttling the CPU / Disk IO for SQL Restore Option

Thanks for the correction, there. I meant to type AWS but it came out as Azure. Not a good reason but that's the reason. 😀
--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, 2018 at 9:01 am

#1998428
RE: How to Split the Sting in SQl Server

Thom A - Friday, July 20, 2018 8:02 AM
Lynn Pettis - Friday, July 20, 2018 7:56 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)

July 20, 2018 at 8:59 am

#1998426
RE: Need Help to convert DATETIME result into DATE on SQL Server

Lynn Pettis - Friday, July 20, 2018 8:20 AM
Jeff Moden - Friday, July 20, 2018 8:10 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)

July 20, 2018 at 8:26 am

#1998415
RE: Storage that Expires

David.Poole - Friday, July 20, 2018 12:16 AM
Tough cases make bad laws.
This is why laws are so complicated and verbose. There...
--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, 2018 at 8:23 am

#1998413
RE: Creating a PDF from a Stored Procedure

For those longing for additional information on this article and code, the author hasn't even logged into SQLServerCentral.com in the last 11 years and has never made a reply 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, 2018 at 8:17 am

#1998409
RE: Need Help to convert DATETIME result into DATE on SQL Server

Jeff Moden - Thursday, July 19, 2018 5:42 PM
Jeff Moden - Wednesday, July 18, 2018 8:10 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)

July 20, 2018 at 8:10 am

#1998405
RE: Throttling the CPU / Disk IO for SQL Restore Option

Sridhar-137443 - Friday, July 20, 2018 7:23 AM
Thank you for your input. I understand that upgrading the server is the 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)

July 20, 2018 at 8:07 am

#1998403
RE: Came Across this vaugly Amusing

SimonH - Friday, July 20, 2018 4:43 AM
https://twitter.com/internetrebecca/status/1020021808764981249
I'll bite... What do you find amusing there?
--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, 2018 at 7:40 am

#1998388
RE: Throttling the CPU / Disk IO for SQL Restore Option

Sridhar-137443 - Thursday, July 19, 2018 9:00 PM
As of now, we have 127 databases. we typically add 1-2 databases every month. If...
--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, 2018 at 9:56 pm

#1998327
RE: separate pipe delimited values in SQL Server

Lynn Pettis - Thursday, July 19, 2018 1:51 PM
Mike01 - Thursday, July 19, 2018 1:36 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)

July 19, 2018 at 9:10 pm

#1998326
RE: Records being added while being deleted as well

Kenn Edwards - Thursday, July 19, 2018 1:02 PM
Hi all,
First off, I have a database that has over 250 million records 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)

July 19, 2018 at 9:02 pm

#1998325
RE: Throttling the CPU / Disk IO for SQL Restore Option

Sue_H - Thursday, July 19, 2018 4:46 PM
Sridhar-137443 - Thursday, July 19, 2018 3:58 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)

July 19, 2018 at 8:55 pm

#1998323
RE: Need Help to convert DATETIME result into DATE on SQL Server

Jeff Moden - Wednesday, July 18, 2018 8:10 PM
jcelko212 32090 - Wednesday, July 18, 2018 7:56 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)

July 19, 2018 at 5:42 pm

#1998321
RE: Need Help to convert DATETIME result into DATE on SQL Server

Nexana - Thursday, July 19, 2018 9:44 AM
Jeff Moden - Thursday, July 19, 2018 8:03 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)

July 19, 2018 at 10:57 am

#1998252
RE: Are the posted questions getting worse?

Lynn Pettis - Thursday, July 19, 2018 8:32 AM
Jeff Moden - Thursday, July 19, 2018 6:51 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)

July 19, 2018 at 8:47 am

#1998217

Viewing 15 posts - 11,761 through 11,775 (of 59,095 total)