Viewing 15 posts - 1,351 through 1,365 (of 2,497 total)
Take Gila's advice. If you do this you will break SQL Server.
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
May 11, 2009 at 2:27 am
Google should find you a few scripts that can do this.
Also, SQL Server FineBuild on Codeplex has scripts to help you transfer logins and roles from SQL 2000 to SQL...
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
May 11, 2009 at 2:25 am
For DTS Packages, msdb database will be transfer to 2008 database, is that right? What about master db? Do I need to transfer that as well.
Don't even think of restoring...
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
May 8, 2009 at 3:14 am
I would also consider talking to my manager to say I do not want the DBA responsibilities I have been offered.
This is obviously a very personal thing -...
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
May 8, 2009 at 3:03 am
It looks like you need to live within the constraints of what a VERY poor vendor is putting on you.
IMHO you should raise these issues with your management, as it...
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
May 8, 2009 at 2:39 am
You need to take a hard look at the business requirements and design your system accordingly.
There is a very big difference between designing a system to cope with a peak...
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
May 8, 2009 at 2:30 am
What are the business requirements. It is hard to advise unless we know what the application needs to do.
You have posted about the transaction table. Is this table...
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
May 7, 2009 at 4:05 am
Yet another update...
I have heard from Microsoft that all the currently available editions of SQL Server 2008 will not be supported by Microsoft on Windows 2008 R2 Core.
Apparently...
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
May 7, 2009 at 4:02 am
You need to set up proxy accounts for each user.
The SQL Server FineBuild Reference document has a detailed description on how to do this, the access rights given, and 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
May 7, 2009 at 3:15 am
Wow what a lot of posts!
Being a former mainframe DB2 DBA and IDUG speaker, and now having some knowledge of SQL Server, I thought I would add my 2p...
There factors...
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
May 5, 2009 at 3:25 am
This question is now also added as Community Content to BOL see http://msdn.microsoft.com/en-us/library/ms143506.aspx
SQL Server FineBuild now supports installing SQL Server 2008 on Windows 2008 R2 Core.
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
May 5, 2009 at 3:06 am
To me, it seems like some kind of programming constraints of mainframes
The strange thing you see is due to the application design, not to the platform it is running on....
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
May 5, 2009 at 3:01 am
VBScript can help you automate repetitive processes, especially where they need a mix of SQL Server tasks and Windows tasks.
SQL Server FineBuild is written using VBScript and some CMD scripts....
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
May 1, 2009 at 6:21 am
It is not just Windows SBS that cannot see more than 4 GB RAM. All 32-bit editions of Windows are not able to address more than 4 GB RAM,...
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 28, 2009 at 3:13 am
This is not the only problem that has been in SQL 2008 iFTS. We are heavy users of FTS in SQL 2005, but found that SQL 2008 iFTS performance...
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 28, 2009 at 2:52 am
Viewing 15 posts - 1,351 through 1,365 (of 2,497 total)