Changing NVARCHAR to VARCHAR...

Question

Changing NVARCHAR to VARCHAR...

Viewing 7 posts - 31 through 36 (of 36 total)

You must be logged in to reply to this topic. Login to reply

Arsh SSCertifiable Points: 6354 More actions · Answer 1

GilaMonster - Friday, November 3, 2017 9:09 AM
Arsh - Thursday, November 2, 2017 7:43 PM
No matter what one does,one is declared 'underperforming' if one doesn't have advanced coding expertise 😉
Oh, I agree with that, DBAs absolutely should have advanced T-SQL skills, plus good powershell skills ideally. Who else is going to teach the developers, identify and tune badly written stored procs, set up monitoring and automation, etc?

Thanks everybody for the valuable insights into this.
Gail, I understand that the DB Admin needs to identify the troublesome code-objects their associated core issues like unnecessary table-scans, missing indexes etc . But should the DBA also train them on HOW TO work with code constructs ? I suppose its the WHAT TO DO is what the DBA point to ...?
Also please recommend any certification on 'Database Architect' as I would like to attain this too.. Thank you.

Arsh SSCertifiable Points: 6354 More actions · Answer 2

Hi,
Also , would it be a huge overhead to SQL server if the " N' " notation for passing the parameters is removed , as the NVARCHAR is converted to VARCHAR as part of design re-consideration. This is a new project , no data and didn't go live. Thank you.

Sergiy SSC Guru Points: 110208 More actions · Answer 3

Arsh - Friday, November 3, 2017 10:44 AM
Thank u Gail. Then what about varchar(4000)? wouldn't it be a better design to use varchar(n) instead of of nvarchar(n) as it'll need half of the pages loaded into memory(assuming there's only one column in this table and no need of multilingual feature) ?

If you're talking about having [n]varchar(4000) fields in your tables than the whole discussion above is totally irrelevant.
Database design which requires 4000 character long strings to be stored in tables is broken beyound repair.
Any discussions about optimising its performance are absolutely pointless.

_____________
Code for TallyGenerator

Jeff Moden SSC Guru Points: 1004434 More actions · Answer 4

Arsh - Tuesday, November 7, 2017 3:24 AM
GilaMonster - Friday, November 3, 2017 9:09 AM
Arsh - Thursday, November 2, 2017 7:43 PM
No matter what one does,one is declared 'underperforming' if one doesn't have advanced coding expertise 😉
Oh, I agree with that, DBAs absolutely should have advanced T-SQL skills, plus good powershell skills ideally. Who else is going to teach the developers, identify and tune badly written stored procs, set up monitoring and automation, etc?
Thanks everybody for the valuable insights into this.
Gail, I understand that the DB Admin needs to identify the troublesome code-objects their associated core issues like unnecessary table-scans, missing indexes etc . But should the DBA also train them on HOW TO work with code constructs ? I suppose its the WHAT TO DO is what the DBA point to ...?
Also please recommend any certification on 'Database Architect' as I would like to attain this too.. Thank you.

Based on the question that you've asked, I'd recommend that you learn a bit more of the basics of SQL Server before going after a "Database Architect" certification.

--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)

Arsh SSCertifiable Points: 6354 More actions · Answer 5

Sergiy - Tuesday, November 7, 2017 5:11 AM
Arsh - Friday, November 3, 2017 10:44 AM
Thank u Gail. Then what about varchar(4000)? wouldn't it be a better design to use varchar(n) instead of of nvarchar(n) as it'll need half of the pages loaded into memory(assuming there's only one column in this table and no need of multilingual feature) ?
If you're talking about having [n]varchar(4000) fields in your tables than the whole discussion above is totally irrelevant.
Database design which requires 4000 character long strings to be stored in tables is broken beyound repair.
Any discussions about optimising its performance are absolutely pointless.

Sergiy ,it's just an example used here by members to understand.Thanks.

Arsh SSCertifiable Points: 6354 More actions · Answer 6

Jeff Moden - Tuesday, November 7, 2017 6:20 AM
Arsh - Tuesday, November 7, 2017 3:24 AM
GilaMonster - Friday, November 3, 2017 9:09 AM
Arsh - Thursday, November 2, 2017 7:43 PM
No matter what one does,one is declared 'underperforming' if one doesn't have advanced coding expertise 😉
Oh, I agree with that, DBAs absolutely should have advanced T-SQL skills, plus good powershell skills ideally. Who else is going to teach the developers, identify and tune badly written stored procs, set up monitoring and automation, etc?
Thanks everybody for the valuable insights into this.
Gail, I understand that the DB Admin needs to identify the troublesome code-objects their associated core issues like unnecessary table-scans, missing indexes etc . But should the DBA also train them on HOW TO work with code constructs ? I suppose its the WHAT TO DO is what the DBA point to ...?
Also please recommend any certification on 'Database Architect' as I would like to attain this too.. Thank you.
Based on the question that you've asked, I'd recommend that you learn a bit more of the basics of SQL Server before going after a "Database Architect" certification.

Hi Jeff. I've been working on SQL server for 7 years now and the weak point is the Database designing (I'm ok only with normalization). Backup/Recovery/ DR/HA solutions , PT experience and other general stuff are all ok at the moment ,if not great ..Would be fantastic if you can mention the name of the certification / course or point to a link. Thank you.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

Arsh - Wednesday, November 8, 2017 12:46 AM
Hi Jeff. I've been working on SQL server for 7 years now and the weak point is the Database designing (I'm ok only with normalization). Backup/Recovery/ DR/HA solutions , PT experience and other general stuff are all ok at the moment ,if not great ..Would be fantastic if you can mention the name of the certification / course or point to a link. Thank you.

The guideline for the MS certified architect, was 10 years experience minimum iirc. I've been working with it for 15 and don't consider myself architect level.
Suggest you spend some time getting what's OK to good, and getting your T-SQL to great, as that's a bare minimum I would consider for even senior DBA, plus Powershell or Bash, depending what OS you work with.

If you want architect, you need a good understanding of the front end design and architectures, so that you know how to to interface with it, so you can add that to your study list. Plus these days at least an awareness of what's in the BI/Analytics area would be essential for a practicing architect.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass