Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,501 through 10,515 (of 59,099 total)

RE: Chinese Characters on report

rinu philip - Tuesday, November 27, 2018 11:33 AM
SQL_Surfer - Sunday, November 4, 2018 1:14 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)

November 28, 2018 at 6:12 am

#2014783
RE: Chinese Characters on report

SQL_Surfer - Sunday, November 4, 2018 1:14 PM
Some of the records that Business Objects pulls are garbage and chinese characters like below.
When...
--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)

November 28, 2018 at 6:11 am

#2014782
RE: poor performing report query against table without a PK

polkadot - Monday, November 26, 2018 12:39 PM
Answers to Qs:
Grant Fritchey: (1) I added parenthesis around Date. (2) using parameters. Attached query.
ChrisM: (1) table...
--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)

November 28, 2018 at 6:05 am

#2014780
RE: View that sums payments by person over a period of years

ScottPletcher - Tuesday, November 27, 2018 2:46 PM
Since you've very likely to (almost) always query by trans date, you should change 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)

November 28, 2018 at 5:56 am

#2014779
RE: Are the posted questions getting worse?

Lynn Pettis - Monday, November 26, 2018 2:36 PM
Well, I have grand kids between 6 and 3 years old, so 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)

November 27, 2018 at 10:22 pm

#2014746
RE: Small negative numbers

Heh... I also find it interesting that most people didn't bark out an "It Depends". Right-sizing is certainly important but so are other considerations such as implicit casts during joins,...
--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)

November 27, 2018 at 10:13 pm

#2014744
RE: Building Better Training Opportunities

Heh... there's nothing more challenging than real life. If you want some problems to work on for training, look at the code you have. Develop a "Continuous Improvement Project" where...
--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)

November 27, 2018 at 10:10 pm

#2014743
RE: What can be the benefits of copy_only backup

I think the biggest benefit is that you can move a "copy only" file anywhere you want it, lose it, or delete it, and it won't affect the possible restores...
--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)

November 27, 2018 at 9:36 pm

#2014741
RE: Converting Binary Numbers To Hex

Steve Jones - SSC Editor - Tuesday, November 27, 2018 9:35 AM
Jeff Moden - Tuesday, November 27,...
--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)

November 27, 2018 at 9:31 pm

#2014740
RE: Converting Binary Numbers To Hex

I'm curious, Steve. With the understanding that the largest positive value you can calculate for BIGINT only occupies 63 bits (and you are only taking positive values into consideration 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)

November 27, 2018 at 9:23 am

#2014677
RE: Converting Binary Numbers To Hex

Phil Factor - Tuesday, November 27, 2018 5:45 AM
Yes, it is an interesting topic with some useful applications
I did a bit on...
--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)

November 27, 2018 at 8:45 am

#2014669
RE: Inserting a new row into a table using a cursor

jcelko212 32090 - Monday, November 26, 2018 12:02 PM
josetur12 - Saturday, November 24, 2018 11:36 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)

November 26, 2018 at 3:04 pm

#2014585
RE: OPENROWSET

Budd - Monday, November 26, 2018 9:28 AM
WHT DOES THIS--
select top 1 a.* into #t
from openrowset('SQLNCLI', 'Server=localhost;Trusted_Connection=yes;','SET NOCOUNT ON;SET FMTONLY OFF;...
--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)

November 26, 2018 at 2:35 pm

#2014582
RE: OPENROWSET

Phil Parkin - Monday, November 26, 2018 9:39 AM
Why are you using OPENROWSET to do this and not issuing the commands directly?
Heh......
--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)

November 26, 2018 at 2:34 pm

#2014581
RE: parse string and check for valid date

Bruin - Monday, November 26, 2018 9:45 AM
How could that be accomplished(example) if no header available.
Thanks.
Read the first row anyway just 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)

November 26, 2018 at 2:32 pm

#2014577

Viewing 15 posts - 10,501 through 10,515 (of 59,099 total)