Viewing 15 posts - 4,726 through 4,740 (of 7,164 total)
Please direct all replies here:
http://www.sqlservercentral.com/Forums/Topic1274667-391-1.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 2:35 pm
GilaMonster (3/28/2012)
opc.three (3/28/2012)
To clarify I am talking about the option set using sp_configure.So am I
Sorry if I implied you misunderstood, I trust you know Default Fill Factor backwards and...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 2:21 pm
Thanks Gail. Funny you should be the first to respond, you inspired me to post this thread out of our bulk-log-friend's post 😀
I did not know anything about the Maintenance...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 1:58 pm
Tools > Options > Environment > General > Open Empty Environment
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 1:46 pm
Sourav-657741 (3/28/2012)
Many thanks for this point too.Unfortunately, at server level the fill factor is set as default (=0). And I can't change it.........since it has been working since long time!
For...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 1:35 pm
Sourav-657741 (3/28/2012)
So, I was thinking to alter the rec model to Bulk-Logged!
Let it go man! 😀
I use this system for index maintenance: Ola Hallengren > SQL Server Index and Statistics...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 1:33 pm
One other item to note that may help you...for your highly fragmented indexes evaluate your fill factors. If you want to reduce fragmentation over time you may benefit from lowering...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 1:27 pm
Maxer (3/28/2012)
When I right click on the table and go to Design it...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 1:23 pm
Sourav-657741 (3/28/2012)
I want to consider two aspects --
1. LDF file should not grow too much...so that at Production server, my drive doesn't run out of space.
2. The size of the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 1:18 pm
Abdul Walele (3/28/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 12:53 pm
I can recreate the issue, but I cannot explain it.
This does not allow [test_dbo] to change the password of [test_default_schema]:
use [master]
GO
GRANT ALTER ON LOGIN::[test_default_schema] TO [test_dbo]
GO
This does, however that is...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 12:42 pm
CodePlex or MSDN TechNet may have some demos. This seems like something Bing should be able to find for you in pretty short order.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 12:32 pm
In throwing around the idea, you should throw it out. There are no compelling reasons to use IMAGE in new development, unless you have legacy clients out there that cannot...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 12:28 pm
I am having this issue as well with the "SQL 2012 - General" forum (RSS). It does not seem to matter whether I am logged into SSC or not.
When not...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 12:21 pm
Eswin (3/28/2012)
I tried Unicode conversion which also dint work.
Do you mean you checked the Unicode box in the SSIS File Connector?
That checkbox is a shortcut to use UCS-2 encoding. You...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 12:05 pm
Viewing 15 posts - 4,726 through 4,740 (of 7,164 total)