Viewing 15 posts - 1,306 through 1,320 (of 2,497 total)
On a 4 GB 32-bit server, the theoretical maximum you can get is 3 GB. For this you will need to have the /3GB switch in boot.ini.
In practice you...
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
June 8, 2009 at 4:17 am
The account running SQL Server needs to have the 'Read Write' privilege on the MSDTC service.
The Windows default is that Everyone has this privilege, but some places tie down this...
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
June 8, 2009 at 4:13 am
I agree with most of what George says, but prefer to treat msdb as a user database and move it, but this is just personal preference.
I like to...
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
June 8, 2009 at 3:23 am
Steve is right. There is nothing in the products that will prevent this from working but you do need to test.
The most likely problems will be in your application,...
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
June 8, 2009 at 3:13 am
If you are asked 'Is anyone in the office wearing a red shirt' what do you do?
a) Go round the entire office counting the number of people and making 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
June 8, 2009 at 3:02 am
See my answer at http://www.sqlservercentral.com/Forums/Topic728579-146-1.aspx? for a script that will do this for you.
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
June 8, 2009 at 2:52 am
There are scripts in FineBuild that can migrate SQL logins complete with their original passwords. You can get FineBuild from the link below or direct from CodePlex. 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
June 8, 2009 at 2:49 am
If you have any Windows support people at your site, talk to them before you change the Hosts file. There are various options that can be used to make...
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
June 8, 2009 at 2:46 am
Sometimes you see announcements on April 1 that SQL Server can run on Linux.
Some people believe them, but so far nobody has got SQL Server working on Linux, but that...
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
June 4, 2009 at 7:13 am
You have to be careful when using @@ROWCOUNT. Your example should work as you expect, but the example below will not...
UPDATE .....
SELECT @MyErr = @@ERROR
IF @@ROWCOUNT > 1 ...
In...
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
June 4, 2009 at 7:09 am
SQL Server is a relational database. You can store objects in SQL Server, but it does not provide any native support for object inheritence.
If you need this suppoprt, then...
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
June 4, 2009 at 7:01 am
The standard way to deal with this is to create a table holding currency codes, the currency symbol, number of decimal places, etc. There is an ISO standard that...
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
June 4, 2009 at 6:54 am
You can use SQL Mail in both SQL 2005 and SQL 2008. It is deprecated and may not exist in the next SQL version but is still supported...
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
June 4, 2009 at 6:48 am
I saw something in the SQL 2008 SP1 fix list that implied you could now move the Resource database, but I have not followed this up yet. IMHO there...
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
June 4, 2009 at 6:42 am
If you want to have a playground environment, then subscribing to TechNet or MSDN is a good idea.
I have subscribed to TechNet for maybe 4 years, and it give me...
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
June 4, 2009 at 6:40 am
Viewing 15 posts - 1,306 through 1,320 (of 2,497 total)