Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,216 through 13,230 (of 59,095 total)

RE: Data transfer

RandomStream - Friday, January 5, 2018 2:58 PM
In case you haven't seen it.
https://serverfault.com/questions/69135/what-is-the-difference-between-bulk-logged-and-simple-recovery-model-which-one/69137
In my opinion BCP requires a trip outside...
--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 5, 2018 at 9:49 pm

#1974800
RE: It's Time to Patch and Upgrade

chrisn-585491 - Friday, January 5, 2018 8:35 PM
Jeff Moden - Friday, January 5, 2018 7:11 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 5, 2018 at 9:39 pm

#1974799
RE: Monitoring is Essential

Considering what has happened with the processor security problems as of late, I strongly suggest that, no matter which tool you use, if you haven't baselined your systems, now would...
--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 5, 2018 at 8:20 pm

#1974796
RE: How to fix my datetime seconds

team.bernard - Friday, January 5, 2018 2:32 PM
Hello,
It's during open hours 8am to 6pm, so it's 8am/10am/12am/2pm/4pm/6pm.
Regards
We don't know what you mean...
--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 5, 2018 at 7:17 pm

#1974794
RE: It's Time to Patch and Upgrade

Things like this scare me to death. Consider how dependent we've become on computers both large and small. Shoot, even my pickup truck is subject to being able to be...
--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 5, 2018 at 7:11 pm

#1974793
RE: Searching strings

Luis Cazares - Friday, January 5, 2018 7:41 AM
Why do you have IDs that are that long? If an ID is 1509...
--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 5, 2018 at 7:02 pm

#1974792
RE: Using Better Tools

What I find strange is that some orgs don't allow any third party tools, free or paid, because they don't come from Microsoft. They may even disallow utilities...
--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 5, 2018 at 7:01 pm

#1974791
RE: Critical SQL Server Patches for Meltdown and Spectre

eg61088 - Friday, January 5, 2018 7:48 AM
Can someone explain why both the OS and SQL Server should be patched? Wouldn't OS...
--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 5, 2018 at 5:56 pm

#1974790
RE: Ola's maintenance solution taking too long on VLDB's

Grant Fritchey - Friday, January 5, 2018 10:07 AM
Jeff Moden - Friday, January 5, 2018 8:50 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 5, 2018 at 3:11 pm

#1974775
RE: What is your typical day like?

RandomStream - Friday, January 5, 2018 12:00 PM
I'm in an environment where the core of the business relies on leased software solutions....
--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 5, 2018 at 2:09 pm

#1974770
RE: Ola's maintenance solution taking too long on VLDB's

Grant Fritchey - Friday, January 5, 2018 6:03 AM
RandomStream - Thursday, January 4, 2018 4:41 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 5, 2018 at 8:50 am

#1974710
RE: Metldown and Spectre

Super Cat - Friday, January 5, 2018 6:53 AM
Please keep me informed.
Read the main article that came out on this site 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)

January 5, 2018 at 8:13 am

#1974702
RE: Ola's maintenance solution taking too long on VLDB's

RandomStream - Thursday, January 4, 2018 5:11 PM
Jeff Moden - Thursday, January 4, 2018 4:50 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 4, 2018 at 5:37 pm

#1974597
RE: Backing up multiple SQL instance and databases using 3rd party software - Any recommendations

Perry Whittle - Wednesday, December 13, 2017 9:36 AM
Steve Jones - SSC Editor - Wednesday, November 22,...
--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 4, 2018 at 4:53 pm

#1974587
RE: Ola's maintenance solution taking too long on VLDB's

RandomStream - Thursday, January 4, 2018 4:41 PM
I experimented with Ola's idea form quite some time and eventually rolled my own solution...
--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 4, 2018 at 4:51 pm

#1974586

Viewing 15 posts - 13,216 through 13,230 (of 59,095 total)