Viewing 15 posts - 301 through 315 (of 2,497 total)
If you sign up to the free Visual Studio Dev Essentials program then you can download and install SQL Server Developer Edition for free. This will give you Analysis...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 6, 2016 at 10:41 am
If they're all on the same spindle, it won't help.
...very true!!
If the OP is looking for the fastest way to backup and restore a 1.5TB database they will try...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 2, 2016 at 3:10 am
jay81 and jasona got there before me, but they have both said something very important. It may not help you with this restore, but could do so for the...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 1, 2016 at 8:31 am
Thinking about my reply a bit more, Service Broker possibly just adds complexity for little gain. You could get much the same effect by using an 'OutboundMessage' to hold...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 28, 2016 at 1:56 am
I am a bit late to this conversation, but here goes...
First, what are the business requirements. How much data will change and how often will it change.
If you are...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 27, 2016 at 11:31 am
20TB is definitely a VLDB, and there are a lot of issues beyond just looking at multiple file groups that you need to consider. A DB of that size...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 24, 2016 at 5:00 am
If you do plan to use MSDTC with AGs on Windows 2012 R2, then you need to check out https://support.microsoft.com/en-us/kb/3090973.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 24, 2016 at 4:51 am
Do not assume that anything running on a computer will be bug-free, especially if it has been written by people. This applies to Availability Groups, old-style mirroring, and transactional...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 19, 2016 at 9:30 am
Using multiple files for a database can be useful regardless of the number of physical volumes (spinning rust or SSD) that a single logical volume gets mapped to.
If your IO...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 19, 2016 at 9:13 am
I would want to look at the 2TB drive, to see
a) how much space is used by logs
b) what else is on the drive
Then I would want to look...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 17, 2016 at 4:10 am
Good points Jeff, I completely agree!
Raising problem tickets is the only workable way forward.
Management should work out for themselves they need to escalate and arrange video links or...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 16, 2016 at 4:19 am
I am going to take a wild guess that there is some unwanted interaction between the backup system and SQL Server. It could be that the backup system has...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 16, 2016 at 4:05 am
Have you considered the 'do-nothing' approach. (Well, almost do nothing...)
Evict node 2 from your cluster, then shut it down and decommission it. You are now running on a...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 16, 2016 at 3:31 am
The number of IP addresses you need depends on what you want to do and how your environment is built and what IP protocols you are using. The number...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 16, 2016 at 3:14 am
I remember 370s. I started work in 1974 at a site with two 370/158 boxes, the largest one had a whole 1MB memory. They both ran OS/MVT, supporting...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 8, 2016 at 12:08 pm
Viewing 15 posts - 301 through 315 (of 2,497 total)