Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,776 through 11,790 (of 59,099 total)

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
RE: Loading more than 1 billion records from CSV File

frederico_fonseca - Thursday, July 19, 2018 7:32 AM
Jeff Moden - Wednesday, July 18, 2018 8:00 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:44 am

#1998215
RE: Are the posted questions getting worse?

Heh... inline with the first interview question about how to get the current date and time, perhaps this should be the second question...
https://www.sqlservercentral.com/Forums/FindPost1977357.aspx
I have 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 19, 2018 at 8:35 am

#1998212
RE: Are the posted questions getting worse?

jasona.work - Thursday, July 19, 2018 6:04 AM
Argh...
So today I was all set to happily telework when it all went sideways in...
--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:05 am

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

Nexana - Wednesday, July 18, 2018 8:23 PM
Jeff Moden - Monday, July 16, 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:03 am

#1998195
RE: Finding a particular date in all tables

Thanks, Ben. I appreciate the time on that.
I guess I'm a bit spoiled... we have a couple centralized audit tables (different functionality groups for each one) for the important...
--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 6:58 am

#1998179
RE: Are the posted questions getting worse?

Lynn Pettis - Wednesday, July 18, 2018 4:04 PM
This is really getting ridiculous. Why is it so hard for people to actual...
--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 6:51 am

#1998177
RE: Loading more than 1 billion records from CSV File

xsevensinzx - Thursday, July 19, 2018 2:45 AM
Yep, BULK INSERT is a great option. I used it as the sole 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 19, 2018 at 6:48 am

#1998174
RE: Importing Tricky CSV Files with PowerShell

Stewart "Arturius" Campbell - Tuesday, July 17, 2018 7:15 AM
Jeff Moden - Tuesday, July 17, 2018 6:14...
--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 18, 2018 at 8:20 pm

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

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

#1998140
RE: Loading more than 1 billion records from CSV File

xsevensinzx - Wednesday, July 18, 2018 5:47 PM
Jeff Moden - Wednesday, July 18, 2018 7:04 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 18, 2018 at 8:00 pm

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

jcelko212 32090 - Wednesday, July 18, 2018 2:17 PM
meichmann - Wednesday, July 18, 2018 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)

July 18, 2018 at 3:24 pm

#1998112

Viewing 15 posts - 11,776 through 11,790 (of 59,099 total)