Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,966 through 16,980 (of 59,067 total)

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
RE: difference betwwn inner join and intersect in sql

There's another huge difference than many overlook. All such operators (Intersect, Except, Union, etc) use NULL = NULL regardless of any server setting to the contrary for "normal"...
--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:03 am

#1896383
RE: Are the posted questions getting worse?

The Dixie Flatline (8/18/2016)
Jeff Moden (8/18/2016)
I guess it's my turn in the proverbial barrel.
http://www.sqlservercentral.com/Forums/FindPost1810510.aspx
For this, you wear the HAT OF SHAME.
Heh... Cross out the "S" and the "E" and it...
--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 7:52 am

#1896353
RE: Tablix assistance please!

David Burrows (8/19/2016)
Jeff Moden (8/18/2016)
You're mistaken. It's not a contest. I'm just interested in possible differences in performance and I'm interested in seeing the actual package because most...
--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 7:35 am

#1896345
RE: Update statistics after Index Rebuild ?

GilaMonster (8/19/2016)
I don't know why that warning sometimes appears. It might be the QO needs multi-column stats, which will not be manually created. I need to research that sometime.
I'd say...
--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 7:31 am

#1896342

Viewing 15 posts - 16,966 through 16,980 (of 59,067 total)