How to Document and Configure SQL Server Instance Settings

Posted on Simple Talk See other posts from Simple Talk
Published on Mon, 30 Jan 2012 00:00:00 GMT Indexed on 2012/03/18 18:15 UTC
Read the original article Hit count: 167

Filed under:

SQL Training

Occasionally, when you install identical databases on two different SQL Server instances, they will behave in surprisingly different ways. Why? Most likely, it is down to different configuration settings. There are around seventy of these settings and the DBA needs to be aware of the effect that many of them have. Brad McGehee explains them all in enough detail to help with most common configuration problems, and suggests some best practices.

Related posts about SQL Training

SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

as seen on SQL Authority - Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL… >>> More
My neural network gets "stuck" while training. Is this normal?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm training a XOR neural network via back-propagation using stochastic gradient descent. The weights of the neural network are initialized to random values between -0.5 and 0.5. The neural network successfully trains itself around 80% of the time. However sometimes it gets "stuck" while backpropagating… >>> More
Enjoy Discounts as High as 25 Percent on Online Training Products in the Microsoft Training Catalog

as seen on Dot net Slackers - Search for 'Dot net Slackers'
Visit the Microsoft Training Catalog to find training and certification resources for Microsoft technologies including SharePoint 2010 and the .NET Framework. Receive discounts on the purchase of online training products in the catalog....Did you know that DotNetSlackers also publishes .net articles… >>> More
My experience working with Teradata SQL Assistant

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Originally posted on: http://geekswithblogs.net/LifeLongTechie/archive/2014/05/28/my-experience-working-with-teradata-sql-assistant.aspx To this date, I still haven't figure out how to "toggle" between my query windows. It seems like unless I click on that "new" button on top, whatever SQL I generate… >>> More
Native JSON-Unterstützung in der Datenbank 12.1.0.2

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Mit dem im Juli 2014 erschienenen Patchset 12.1.0.2 wird die Oracle-Datenbank erstmals mit nativer Unterstützung für JSON ausgestattet: So ist es unter anderem nun möglich ... JSON in Tabellen zu speichern und zu validieren Daten aus JSON-Dokumenten zu extrahieren "Relationale… >>> More

Developer IT

How to Document and Configure SQL Server Instance Settings - Developer IT

How to Document and Configure SQL Server Instance Settings

SQL Training

Related posts about SQL Training

SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

My neural network gets "stuck" while training. Is this normal?

Enjoy Discounts as High as 25 Percent on Online Training Products in the Microsoft Training Catalog

My experience working with Teradata SQL Assistant

Native JSON-Unterstützung in der Datenbank 12.1.0.2

Categories cloud