Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,521 through 11,535 (of 59,099 total)

RE: 2 identical plans - different performance when query run on different servers

PearlJammer1 - Tuesday, August 14, 2018 5:31 PM
Hi - This is a very odd behaviour and the opposite of what you may...
--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)

August 14, 2018 at 7:45 pm

#2001769
RE: Deleted

chocthree - Tuesday, August 14, 2018 6:56 AM
Hi,
I hope this is the right forum to ask this question. Not sure where else...
--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)

August 14, 2018 at 12:08 pm

#2001735
RE: Huge number of tables

JackCarrington - Tuesday, August 14, 2018 8:32 AM
ThomasRushton - Tuesday, August 14, 2018 6:38 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)

August 14, 2018 at 9:25 am

#2001680
RE: The SQL Saturday Thread

robert.sterbal 56890 - Tuesday, August 14, 2018 8:15 AM
Where would be the most logical place to develop a guide?
On the PASS/SQLSaturday...
--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)

August 14, 2018 at 8:23 am

#2001653
RE: SSMS failing to install on windows 10

hurricaneDBA - Tuesday, August 14, 2018 5:57 AM
Hi Erik / Sue
I had one of my colleagues in the systems team look...
--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)

August 14, 2018 at 7:54 am

#2001645
RE: How much RAM required to server

So how much RAM do you currently have and how many CPUs are running at 86%?
Also, a 300GB database with 15-20 million rows (you still haven't stated what...
--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)

August 14, 2018 at 6:58 am

#2001628
RE: Why QUOTENAME is important

peter.row - Tuesday, August 14, 2018 4:06 AM
What I'd really like is a QUOTENAME function that only quoted if the name required...
--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)

August 14, 2018 at 6:28 am

#2001622
RE: Why QUOTENAME is important

Thom A - Tuesday, August 14, 2018 4:19 AM
peter.row - Tuesday, August 14, 2018 4:06 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)

August 14, 2018 at 6:24 am

#2001619
RE: Why QUOTENAME is important

RonKyle - Monday, August 13, 2018 11:19 AM
Thom A - Monday, August 13, 2018 9:08 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)

August 14, 2018 at 6:16 am

#2001617
RE: The SQL Saturday Thread

@steve-2 Jones,
Hope you're still going to Pittsburgh. It's been a while since I've seen you in person. I also know that Ed Wagner is very much looking forward 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)

August 14, 2018 at 6:06 am

#2001616
RE: Problem Converting DATE. Trying to Purge Data Oldest than 30 days from Performance Counter Table where date column is char (24)

Jonathan AC Roberts - Monday, August 13, 2018 3:34 AM
Jeff Moden - Sunday, August 12, 2018 3:53...
--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)

August 13, 2018 at 8:22 pm

#2001570
RE: The SQL Saturday Thread

robert.sterbal 56890 - Monday, August 13, 2018 10:15 AM
Ed Wagner - Wednesday, July 11, 2018 2:09 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)

August 13, 2018 at 3:28 pm

#2001562
RE: Huge number of tables

JackCarrington - Monday, August 13, 2018 6:46 AM
Jeff Moden - Saturday, August 11, 2018 1:13 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)

August 13, 2018 at 3:24 pm

#2001561
RE: The TSB disaster: Where were the grown-ups?

Another proof that if you want it real bad, that's the way you'll get it. 😀
--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)

August 13, 2018 at 8:42 am

#2001490
RE: What does your backup process look like?

To be honest, I wouldn't change from the original backup plan except to do the transaction log backups every half hour. Restoration of a database that only has weekly backups...
--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)

August 13, 2018 at 8:40 am

#2001487

Viewing 15 posts - 11,521 through 11,535 (of 59,099 total)