Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,996 through 17,010 (of 59,101 total)

RE: BCP program VS BULK INSERT query

SQL!$@w$0ME (8/22/2016)
Hi Folks,
What is the difference between BCP program and BULK INSERT. Are they both the same in terms of performance? I am trying to find a solution for bulk...
--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)

August 22, 2016 at 9:44 am

#1896689
RE: Still Confused about the difference between varchar(max) and varchar(8000)

RonKyle (8/19/2016)
Also, use numeric data types when appropriate (FYI, telephones and zip codes are not numeric data).
Social Security numbers are also not numeric. Once had a discussion with...
--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)

August 22, 2016 at 8:26 am

#1896665
RE: Are the posted questions getting worse?

Sean Lange (8/22/2016)
I have always been accused of being a little over the top about making sure we have backups of everything in place in case we need to rollback...
--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)

August 22, 2016 at 8:20 am

#1896661
RE: Can we shrink datafile of a database which is configured with log shipping

JasonClark (8/21/2016)
you can use NOTRUNCATE option with DBCC shrinkfile command.
That will certainly avoid fragmentation problems but will provide mixed results and will likely not return all unused space because 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)

August 22, 2016 at 7:48 am

#1896650
RE: Tablix assistance please!

Heh... my test bed contained 26 products over 7 years with a million rows per year so I think you're probably all set for scalability. 😛
My question on 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)

August 22, 2016 at 7:26 am

#1896642
RE: Minimal Logging

~~I also state that the INSERT...SELECT minimal logging isn't worth a hoot. According to a source at MS, it does "double writing" in the MDF file (that would be...~~
--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)

August 21, 2016 at 9:28 pm

#1896547
RE: Minimal Logging

kevaburg (9/29/2013)
If I switch from FULL to the BULK-LOGGED recovery model, don't I lose what is currently in the transaction log?
I know this is a old post but the answer...
--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)

August 21, 2016 at 9:08 pm

#1896546
RE: Is SQL Server Replication going away?

Lynn Pettis (8/19/2016)
Jeff Moden (8/19/2016)
pooyan_pdm (8/19/2016)
This is a gray area. Replication is deprecated and there's no true replacement for it at this time.
Not using Replication in future deployments is...
--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)

August 21, 2016 at 6:16 pm

#1896540
RE: Parallel insert in a table

There are plenty of methods for supposed "parallel loads" but none of those methods change physics. If the table exists only on one spindle, there's only one read/write head....
--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)

August 21, 2016 at 6:02 pm

#1896538
RE: Is SQL Server Replication going away?

pooyan_pdm (8/19/2016)
there is difference between "deprecated" and "discontinued". Replication is still supported and not yet "discontinued" as there's no true replacement for it yet,but MS has not been adding anything...
--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)

August 19, 2016 at 1:22 pm

#1896435
RE: Partition and Index Alignment

alex.sqldba (8/17/2016)
Oh. Very interesting. You are changing my mind.
There are a couple of reasons for considering partitioning, Jeff - as follows:
1. Performance whilst not the focus it's also not lightning...
--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)

August 19, 2016 at 1:05 pm

#1896431
RE: Is SQL Server Replication going away?

pooyan_pdm (8/19/2016)
This is a gray area. Replication is deprecated and there's no true replacement for it at this time.
Not using Replication in future deployments is based on some of...
--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)

August 19, 2016 at 12:57 pm

#1896429
RE: Can we shrink datafile of a database which is configured with log shipping

info.sqldbamail (8/19/2016)
Hello Everyone,
I have a primary database Server A and Secondary Database Server B Log shipping configured on A to B of a database,
1) Database size 500 GB,...
--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)

August 19, 2016 at 12:48 pm

#1896426
RE: xp_cmdshell Error code: 0x80004005

vprunic (8/19/2016)
Hello all,
what does this mean?
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult:...
--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)

August 19, 2016 at 12:43 pm

#1896425
RE: Suggest me a book

policeudaykumar (8/19/2016)
Hello everyone,
Greetings of the day!
I am currently working in Non-IT profile.
I wish to learn SQL DBA and move to this profile altogether. I request everybody here to support me...
--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)

August 19, 2016 at 10:13 am

#1896388

Viewing 15 posts - 16,996 through 17,010 (of 59,101 total)