Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,346 through 15,360 (of 59,063 total)

RE: column collation - the mystery of it all ?

To be honest, I don't know the answer to your latest question. I have a difficult enough time even getting people to use CR/LF symbols consistently for imports.
--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 1:26 pm

#1934643
RE: row size exceeds the maximum 8060

sqlfriends - Thursday, March 23, 2017 12:19 PM
Also we do added some columns recently and dropped some. Is there a way 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)

March 23, 2017 at 1:17 pm

#1934641
RE: Comparing Space Usage for Different Compression Types

Good summary. Thanks for taking the time to do the experiments and to write up your conclusions.
Shifting gears a bit, I can't speak for anyone else but I...
--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 7:36 am

#1934508
RE: Missing index with change impact percentage

kumar.bhupendra - Wednesday, March 22, 2017 8:17 PM
Hi Aruna,
I am very new to Database, can u tell me how to run this...
--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 22, 2017 at 11:20 pm

#1934442
RE: row size exceeds the maximum 8060

Gosh... sounds odd. The only way I can see this happening is if there are enough fixed length columns to push you over the 8060 limit. Varchars will go "out...
--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 22, 2017 at 11:16 pm

#1934441
RE: Hierarchy without cursor/loop

If you want to go whole hog on hierarchies, see the following articles
http://www.sqlservercentral.com/articles/Hierarchy/94040/
http://www.sqlservercentral.com/articles/T-SQL/94570/
--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 22, 2017 at 10:51 pm

#1934438
RE: column collation - the mystery of it all ?

szejiekoh - Wednesday, March 22, 2017 10:30 AM
Jeff Moden - Sunday, March 19, 2017 1:53 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 22, 2017 at 10:34 pm

#1934437
RE: Find UDF useage

I also think it's worth mentioning that Scalar UDFs, although certainly can be bad especially when compared to their iTVF cousins, are usually not the top concern on a system...
--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 22, 2017 at 10:21 pm

#1934436
RE: Hierarchy without cursor/loop

ansaryarshad - Wednesday, March 22, 2017 3:52 AM
Hi Thom,
Sorry for the reply.
I am coming from an SAP HANA background where CTEs...
--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 22, 2017 at 7:49 am

#1934293
RE: BCP OUT using Error file makes sense?

Hans van Dam - Tuesday, March 21, 2017 8:33 AM
Hi Jeff, thanks, but I guess I wasnt clear. What I actually...
--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 21, 2017 at 10:12 pm

#1934247
RE: xp_cmdshell and echo - trouble with escape

Nah... don't be sorry. You posted a great example of how it works correctly.
--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 21, 2017 at 10:05 pm

#1934246
RE: What can dbowner not do?

dan-572483 - Tuesday, March 21, 2017 6:59 PM
Like many application this particular application has a database connection config screen with a "Test...
--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 21, 2017 at 9:52 pm

#1934245
RE: What can dbowner not do?

I agree.... no one but seriously trusted internal DBAs should have "SA" (sysadmin) privs. No applications, not even so called "system monitoring" software needs it. We're 1/6th of the way through...
--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 21, 2017 at 5:53 pm

#1934239
RE: xp_cmdshell and echo - trouble with escape

Sue_H - Tuesday, March 21, 2017 8:31 AM
j mukherjee - Monday, March 20, 2017 8:20 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 21, 2017 at 5:21 pm

#1934237
RE: xp_cmdshell and echo - trouble with escape

j mukherjee - Monday, March 20, 2017 8:20 PM
This works:
SET @CommandL1 = 'echo U1 '+@ClientID+''> c:\temp\file.txt'
exec master..xp_cmdshell @CommandL1
The exact same command as above...
--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 21, 2017 at 8:22 am

#1934159

Viewing 15 posts - 15,346 through 15,360 (of 59,063 total)