Jeff Moden

Forum Replies Created

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

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
RE: Looking for an idea how to construct this T-SQL Select Statement

drew.allen - Monday, August 13, 2018 8:27 AM
andycadley - Sunday, August 12, 2018 5:18 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 13, 2018 at 8:29 am

#2001482
RE: Unwired for Weeks

GeorgeCopeland - Friday, August 10, 2018 1:32 PM
Agile methodology is a gift from god. You are right: if people keep having...
--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 6:28 am

#2001452
RE: Are the posted questions getting worse?

Beatrix Kiddo - Monday, August 13, 2018 3:26 AM
Hmm, I would use indices in a financial markets context, but indexes in a...
--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 6:19 am

#2001450
RE: Urgent:Transaction Rollback

My very strong recommendation would be to not screw with anything during the rollback. Been there, done dat.
--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 6:09 am

#2001448

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