Jeff Moden

Forum Replies Created

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

RE: Searching strings

richardmgreen1 - Monday, January 8, 2018 7:28 AM
I was afraid of that, but thanks anyway.
Looks like an "improvement suggestion" is heading back...
--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 8, 2018 at 8:13 am

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

Eric M Russell - Sunday, January 7, 2018 9:47 AM
Jeff Moden - Friday, January 5, 2018 7:11...
--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 7, 2018 at 10:27 am

#1974834
RE: It's the Engineers

xsevensinzx - Sunday, January 7, 2018 9:10 AM
I wouldn't put it all on the engineers though. Plenty of cases where the business...
--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 7, 2018 at 10:09 am

#1974832
RE: It's the Engineers

xsevensinzx - Saturday, January 6, 2018 9:32 PM
Jeff Moden - Saturday, January 6, 2018 7:22 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 7, 2018 at 8:50 am

#1974828
RE: It's the Engineers

Good article but I really don't understand why you say that relational databases are really only good for small scale stuff. Is there no one that you would consider "large"...
--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 6, 2018 at 7:22 pm

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

Steve, thanks a ton for putting this together especially on "repeat Friday". It sure did make finding things easy.
--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 6, 2018 at 7:12 pm

#1974816
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

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