Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,036 through 19,050 (of 59,098 total)

RE: Rethinking Hiring

Ah... sorry Gary. I knew what you were getting at. Didn't mean to make it look like I was sniping you. It's just that I'm both...
--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)

December 9, 2015 at 9:18 am

#1844956
RE: How to pad a string with spaces when size of data is unknown

ChrisM@Work (12/9/2015)
suvesh.sonker 2691 (12/9/2015)
-- Ten digit
Declare @field as varchar(20) = '559'
Select Replace(right(replicate(' ',10) + @field ,10),' ','0')
In what circumstances might this be preferable to the simpler SELECT RIGHT('0000000000'+@field,10)?
When you have...
--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)

December 9, 2015 at 9:14 am

#1844955
RE: Rethinking Hiring

Gary Varga (12/8/2015)
There are technical fundamentals that I would expect practitioners at the applicable level to understand and be able to describe, however, I never expect anyone to remember syntax...
--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)

December 9, 2015 at 9:02 am

#1844946
RE: Rethinking Hiring

Rod at work (12/8/2015)
Having recently been unemployed for a long period of time, I had many interviews. (Most by phone, some Skype or WebEx and those that were local were...
--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)

December 9, 2015 at 8:41 am

#1844933
RE: Are the posted questions getting worse?

Just making sure that I can post here. They had some major problems with my account. I couldn't even see this forum never mind post anything here.
--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)

December 9, 2015 at 8:22 am

#1844923
RE: TSQL Recursive Help

Heh... I'm a little aggressive because of what? Recommending that you format your code and use meaningful aliases or the recommendation to change the data to be a true...
--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)

December 9, 2015 at 8:17 am

#1844915
RE: Rebuild index job runs for a long time

Chitown (12/7/2015)
I have Index Rebuild job which usually runs everyweek and takes about 15-20 minutes (Average time). Couple of times, it ran for 2+ hours. I found this script online...
--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)

December 7, 2015 at 11:28 pm

#1844551
RE: What is an alternative for xp_cmdshell

naufymc (12/6/2015)
Here xp_cmdshell is disabled ,Please let me know an alternative method for this
That's a shame. It's a powerful tool. They should learn that it can be used...
--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)

December 7, 2015 at 11:22 pm

#1844550
RE: Import text cell value from Excel to sql

pwalter83 (12/7/2015)
msbisyed (12/7/2015)
HI Mays,
Same Issue was there when I'd work on the Excel to SQL and vice versa.
This is ('01/01/1900 ) default time stamp.
TRY This: - Select the...
--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)

December 7, 2015 at 11:14 pm

#1844549
RE: Is it possible to format Excel/CSV file into fmt/XML file via BCP

shelir (12/7/2015)
I installed both Import and Export Data Wizard (64 bit) and Import and Export Data Wizard (32 bit). Since Access and Excel have only 32 bit version provider the...
--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)

December 7, 2015 at 10:51 pm

#1844547
RE: TSQL Recursive Help

OK. The first problem with all of this is that you've not used Bike10 as a child and so you have to do all sorts of different stuff because...
--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)

December 7, 2015 at 10:36 pm

#1844543
RE: Responsibilities of L1-DBA

eluriraja (12/6/2015)
Hello sir, i'm Raja..
I've opening on L1- DBA....
So I want to know about the " Responsibilities of L1-DBA "...
SO Can you tell me " What are the...
--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)

December 7, 2015 at 9:16 pm

#1844538
RE: TSQL Recursive Help

Since we don't have your data nor even your table structure, I have to ask... what is the code not doing?
--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)

December 7, 2015 at 6:46 pm

#1844523
RE: report print layout fine but normal layout ko

Andy H Kwok (12/6/2015)
Hi Jeff,
Thanks but do you have more meaty insights by any chance? 🙂
Best,
Andy
Unfortunately, no. The two views of reports were designed to provide different functionality and...
--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)

December 7, 2015 at 10:15 am

#1844435
RE: Regarding Transaction log backup

SQL-DBA-01 (12/4/2015)
Thnx...That is how it works. I will pass on the links to d other db champs..
I've been following a lot of your posts over the last 6 months. ...
--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)

December 6, 2015 at 1:05 pm

#1844257

Viewing 15 posts - 19,036 through 19,050 (of 59,098 total)