Viewing 15 posts - 16,966 through 16,980 (of 59,067 total)
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
Change is inevitable... Change for the better is not.
August 22, 2016 at 7:26 am
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
Change is inevitable... Change for the better is not.
August 21, 2016 at 9:28 pm
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
Change is inevitable... Change for the better is not.
August 21, 2016 at 9:08 pm
Lynn Pettis (8/19/2016)
Jeff Moden (8/19/2016)
pooyan_pdm (8/19/2016)
Not using Replication in future deployments is...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 21, 2016 at 6:16 pm
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
Change is inevitable... Change for the better is not.
August 21, 2016 at 6:02 pm
pooyan_pdm (8/19/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 19, 2016 at 1:22 pm
alex.sqldba (8/17/2016)
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
Change is inevitable... Change for the better is not.
August 19, 2016 at 1:05 pm
pooyan_pdm (8/19/2016)
Not using Replication in future deployments is based on some of...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 19, 2016 at 12:57 pm
info.sqldbamail (8/19/2016)
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
Change is inevitable... Change for the better is not.
August 19, 2016 at 12:48 pm
vprunic (8/19/2016)
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
Change is inevitable... Change for the better is not.
August 19, 2016 at 12:43 pm
policeudaykumar (8/19/2016)
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
Change is inevitable... Change for the better is not.
August 19, 2016 at 10:13 am
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
Change is inevitable... Change for the better is not.
August 19, 2016 at 10:03 am
The Dixie Flatline (8/18/2016)
Jeff Moden (8/18/2016)
I guess it's my turn in the proverbial barrel.For this, you wear the HAT OF SHAME.
Heh... Cross out the "S" and the "E" and it...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 19, 2016 at 7:52 am
David Burrows (8/19/2016)
Jeff Moden (8/18/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 19, 2016 at 7:35 am
GilaMonster (8/19/2016)
I'd say...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 19, 2016 at 7:31 am
Viewing 15 posts - 16,966 through 16,980 (of 59,067 total)