Viewing 15 posts - 1,261 through 1,275 (of 2,497 total)
W2003 R2 Standard can use up to 32 GB memory. You should check out other changes that came with R2 for W2003, they may also be useful.
Why are 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
July 8, 2009 at 5:17 am
The page size in SQL Server is 8K because the SQL Server authors made it that way.
Some other database systems allow the DBA to specify the page size. 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
July 8, 2009 at 5:09 am
A table only get partitioned when a partitioning scheme and partitioning function has been defined for it. The number of rows in a table has no impact on 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
July 8, 2009 at 4:59 am
If you are doing performance testing, then you need to make sure your environments are the same. This can be difficult.
Are you using the same type of computer hardware...
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
July 7, 2009 at 4:07 am
The proportional fill algorithm is a lot more simple than maybe some people think.
When SQL Server wants to add an extent of space to an object the 'proportional fill' algorithm...
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
July 3, 2009 at 6:24 am
I'm sure I clicked in 'calculating index key size' when I looked at BOL, but the info is actually in 'Estimating the size of a nonclustered index'. I am...
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
July 2, 2009 at 5:16 am
Hugo, 'calculating index key size' in BOL disagrees with what you said. I hesitate to say which source is wrong 🙂
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
July 2, 2009 at 4:24 am
I got is right but imho all the answers as given are wrong.
Varchar does not just use the space required for the number of characters in the row. 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
July 2, 2009 at 3:18 am
The figure you are looking at is calculated from the control information held about tables in tempdb.
tempdb has what is known as lazy garbage collection. When an object is...
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
July 1, 2009 at 3:01 am
You say you will be upgrading on to new machines. In this situation you cannot upgrade your old system databases, you must use the new system databases installed with...
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
July 1, 2009 at 2:45 am
What properties are you looking at?
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
July 1, 2009 at 2:32 am
If you look at some of the more recent blogs from some of the Windows, my view is there is a general agreement that the functionality tied up with /PAE...
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 30, 2009 at 4:57 am
There are lots of threads on this topic. See my post on http://www.sqlservercentral.com/Forums/Topic737423-146-1.aspx for more details of the setup you need to run DTS on SQL Server 2005 and...
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 29, 2009 at 2:51 am
The switch is called /3GB, not /GB.
Yes, you will need the /3GB switch to allow SQL Serve rto use more memory. You will only get 3GB useable by 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
June 29, 2009 at 2:45 am
As far as I can see, most of the stuff that is put on the system drive has to be there.
The SQL install adds a lot of files to 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
June 26, 2009 at 9:08 am
Viewing 15 posts - 1,261 through 1,275 (of 2,497 total)