Viewing 15 posts - 1,681 through 1,695 (of 2,497 total)
There are 2 issues - SQL table & index fragmentation, and NTFS disk fragmentation.
To reduce the size of your database, I would look at a) delete the unwanted data, b)...
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 9, 2008 at 3:28 am
There is a sp in SqlServerFindBuild that does a bulk export of DTS packages. The sp outputs to structured storage files, but it is easy to tweak the output...
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 9, 2008 at 3:22 am
There has been a lot of incorrect information posted in this thread about /3GB and /PAE!
Colin Leversuch-Roberts spends his (working) life fixing SQL performance issues. If you want 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
April 9, 2008 at 3:14 am
There are a number of scripts on the web that can do a bulk export of DTS packages. Most of them (including those in SqlServerFineBuild) are aimed at transferring...
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 9, 2008 at 2:57 am
Just for intrerest, why do you want to limit the number of connections? SQL Server can easily cope with hundreds of simultaneous connections.
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 9, 2008 at 2:53 am
What are your objectives in doing this work?
If you simply want to get naming conventions and coding standards to comply with current site requirements, IMHO this is a total waste...
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 9, 2008 at 2:51 am
Almost certainly the account needs the 'logon as a batch job' right.
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 9, 2008 at 2:31 am
Also take a look at a TechNet Plus Direct subscription. This gives you all the MS server and office software for personal use. No time restrictions. 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
April 8, 2008 at 3:03 am
I agree with K Brian Kelly. The most likely cause of the error message is that SQL Server cannot verify that the account exists. Check that the domain...
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 8, 2008 at 2:40 am
oops, I overstated it a bit...
The ISO 15408 standard covering what is called Common Criteria was ratified in 1999, and revised in 2005. The drive to create...
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 4, 2008 at 6:22 am
If you want a SQL Server 2005 cluster it has to be installed as a cluster. You cannot upgrade a non-clustered instance to clustered.
You have a lot of risk...
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 4, 2008 at 2:55 am
Open the Windows Service Control applet and navigate to the SQL Server service. Look at the Recovery tab, and you see you can specify a script to run if...
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 3, 2008 at 3:09 am
Don't even try this!
None of the system databases can be moved from SQL Server 2000 to SQL Server 2005. You need to script out all user objects...
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 3, 2008 at 3:05 am
Be aware that the concept of 'C2 Auditing' is obsolete. The C2 level was based on the old US DOD 'Trusted Computer System Evaluation Criteria', that became obsolete almost...
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 3, 2008 at 2:56 am
You need to do inegrity checks, but there are pros and cons for including them in the backup process. You need to decide what is best for your site.
Pros...
1)...
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, 2008 at 3:52 am
Viewing 15 posts - 1,681 through 1,695 (of 2,497 total)