Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,361 through 15,375 (of 59,101 total)

RE: Is full backup enough

My recommendation stands as it did on the other thread.
1. I assume you're doing normal full backups at the very least. If they're not being done daily, that's...
--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)

March 25, 2017 at 6:26 pm

#1934952
RE: Are the posted questions getting worse?

Heh... "DevOps Specialist". IMHO, that should be the poster-child word example for "oxymoron". 😉
--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)

March 25, 2017 at 4:04 pm

#1934947
RE: Continuous Delivery and the Development DBA

Nothing to do with the article... I'm just really happy that I don't work for a company with 15 development teams and 100+ developers. 😉
--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)

March 24, 2017 at 4:46 pm

#1934911
RE: Tlog backups - indicate no data change

sqlguy80 - Friday, March 24, 2017 12:38 PM
Hi,
For the db backup restore project moving ~ 1200 dbs ( some vldbs 500 GB...
--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)

March 24, 2017 at 4:32 pm

#1934910
RE: Update SQL with excel files?

stino - Friday, March 24, 2017 4:23 PM
Hi,
i need to update 1500 employee records,
my new data i have in Excel,...
--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)

March 24, 2017 at 4:29 pm

#1934909
RE: I'm "working from home"

I've found that working from home on a dedicated project allows me to get a whole lot more done... if I ignore the company email, urgent PMs, text messages, etc,...
--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)

March 24, 2017 at 4:10 pm

#1934905
RE: Columns to rows and rows to columns

p.shabbir - Friday, March 24, 2017 1:17 PM
Hi,
I have table like below.
START_DATE    END_DATE    COUNTRY        VALUES
1/1/2017        2/1/2017        USA                      20
1/1/2017        2/1/2017        INDIA          50
1/1/2017        2/1/2017        AUSTRALIA   ...
--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)

March 24, 2017 at 3:56 pm

#1934902
RE: Format of File Before Bulk Insert

John215 - Friday, March 24, 2017 1:45 PM
Hello all,
I have files that come in everyday that needs to be bulk inserted. Some...
--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)

March 24, 2017 at 3:42 pm

#1934900
RE: Database Documention Tool

Grant Fritchey - Friday, March 24, 2017 3:22 PM
Eric M Russell - Friday, March 24, 2017 8:06...
--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)

March 24, 2017 at 3:34 pm

#1934898
RE: Instance is under memory pressure. How to relieve from pressure

SQLRNNR - Friday, March 24, 2017 3:21 PM
I believe the real answer to this question is that the user is running maintenance...
--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)

March 24, 2017 at 3:28 pm

#1934897
RE: Instance is under memory pressure. How to relieve from pressure

Jeff Moden - Friday, March 24, 2017 10:40 AM
coolchaitu - Friday, March 24, 2017 10:07 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)

March 24, 2017 at 2:53 pm

#1934880
RE: Instance is under memory pressure. How to relieve from pressure

coolchaitu - Friday, March 24, 2017 10:07 AM
Instance is under memory pressure. How to relieve it from pressure
The two most common causes...
--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)

March 24, 2017 at 10:40 am

#1934829
RE: Are the posted questions getting worse?

jasona.work - Friday, March 24, 2017 10:16 AM
Ah, the urge to post a snarky response to a poorly posed question...
"Question": "Instance under...
--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)

March 24, 2017 at 10:26 am

#1934819
RE: Execution Plan Training Suggestions

The problem that you may be having is that you "thumbed through" Grant's books. If you do a deep study of his books, everything you ask for will become self...
--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)

March 24, 2017 at 8:13 am

#1934765
RE: sp_send_dbmail executes query but not sending the email - error

Very cool feedback. Thanks for taking the time. I would never have come up with that because I thought you were operating with a "sysadmin" privs. Bad assumption on my...
--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)

March 24, 2017 at 7:36 am

#1934749

Viewing 15 posts - 15,361 through 15,375 (of 59,101 total)