Jeff Moden

Forum Replies Created

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

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
RE: Change Approvals

mike.mcquillan - Friday, March 24, 2017 2:52 AM
I 100% agree with Jeff...nobody should deploy their own code.
Sadly, the reality I've encountered is...
--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:31 am

#1934746
RE: row size exceeds the maximum 8060

Sergiy - Friday, March 24, 2017 2:54 AM
sqlfriends - Wednesday, March 22, 2017 7:42 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)

March 24, 2017 at 7:13 am

#1934739
RE: Change Approvals

We have a standard... no one promotes their own code... period.
We also have another standard that identifies the development, testing, and production deployment processes including peer review, QA...
--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 23, 2017 at 11:58 pm

#1934686
RE: dbcc shrinkfile()

frederico_fonseca - Thursday, March 23, 2017 6:32 PM
Something like this.

declare @sql nvarchar(300)
declare @shrink_step int = 20000 -- size in MB to reduce
declare...
--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 23, 2017 at 11:50 pm

#1934685

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