Viewing 15 posts - 1,261 through 1,275 (of 2,496 total)
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...
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...
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...
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...
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...
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 🙂
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...
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...
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...
July 1, 2009 at 2:45 am
What properties are you looking at?
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...
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...
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...
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...
June 26, 2009 at 9:08 am
The root cause may be that bot instances are trying to listen on port 1433.
One way to diagnose if this is a likely cause is:
a) Can you connect to instance...
June 26, 2009 at 3:12 am
Viewing 15 posts - 1,261 through 1,275 (of 2,496 total)