Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,006 through 19,020 (of 59,072 total)

RE: how to speed up sp_testlinkedserver

It's not sp_testlinkedserver that's slow. It's the connection that is slow. That could be anything between the server where the linked server has been created to the target...
--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 11:26 am

#1845021
RE: How to catch actual parameter value passed into a stored procedure?

SQL Guy 1 (12/8/2015)
I am running server-side trace to catch a certain stored procedure and its parameter values. I am tracing event SP:Completed with a filter for ObjectName column.
In...
--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 11:19 am

#1845019
RE: Rethinking Hiring

Rod at work (12/9/2015)
I can't remember what the function was I was asked to write and then test, but it was something like writing a function that would approximate 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 9, 2015 at 10:31 am

#1844996
RE: Rethinking Hiring

Steve Jones - SSC Editor (12/2/2015)
Rod at work (12/2/2015)
Oh Steve, man have you said a lot here that I'd like to respond to. But I think prudence forebears me from...
--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:31 am

#1844969
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

Viewing 15 posts - 19,006 through 19,020 (of 59,072 total)