Viewing 15 posts - 61 through 75 (of 85 total)
If you only want to shrink the log file then you need to use the DBCC SHRINKFILE command. YOu use the logical file name not the phyiscal file name. You...
April 22, 2004 at 9:47 am
Yes, TempDB is recreated each time SQL Server is restarted. However, if some one has increased the file size (for either the data or log file) from the default then...
April 21, 2004 at 12:16 pm
The only way to really control the size of the log and data files is to turn off auto grow. If the files have grown too large already but there...
April 21, 2004 at 11:07 am
First I hope you mean that the size is 13GB and not 13MB. Second, these files ARE your database and regardless of whether you have actual data in them or...
April 21, 2004 at 9:19 am
Your car analogy is way off base. A more appropriate analogy would be if after you bought your car the dealership rolled out all the parts and said all you...
January 30, 2004 at 12:56 pm
MS gives things away for a very specific reason. To crush competition. They can do this because they have monopolies in two very important software categories. Using a monopoly that...
January 30, 2004 at 10:51 am
All good posts but the bottom line is Microsoft produced an incomplete product that requires the purchase of another tool in order to use it. If product was supposed to be...
January 28, 2004 at 4:34 pm
While zero is "practical" the command in Answer A will generate an error. It is not valid to specify a fill factor of zero in a CREATE INDEX statement. It's...
January 24, 2004 at 11:52 am
That seems to explain the main inconsistency. However, it should still not state that specifying no fillfactor will default to a fillfactor of 0.
Yes, the BOL is unclear (if not...
January 23, 2004 at 11:30 am
If you would read the posts in this forum first your question would have already been answered.
January 23, 2004 at 10:31 am
OK, after a little more looking here's the correct explanation:
It (zero) is different from 100 in that SQL Server leaves some space within the upper level of the index tree....
January 23, 2004 at 7:36 am
When I read the answers to the question I thought both A and D would provide the same result. So, I went ot the BOL to see if it said...
January 23, 2004 at 7:31 am
quote:
Hi thereLets see, multiple database servers all working simultaneously on the same database files, now thats my idea of scaling out. ...
December 4, 2003 at 9:18 am
For web servers you can set the web service process user to a domain account (much like the you set the SQL Server service user account). Of course you'd...
December 4, 2003 at 8:13 am
Well, I don't have any issues. I don't have a system implementing federated databases I was just thinking about this as I read the article. However, I am...
December 4, 2003 at 7:22 am
Viewing 15 posts - 61 through 75 (of 85 total)