Viewing 15 posts - 4,726 through 4,740 (of 7,168 total)
I agree with everything that's been said so far in terms of using NT Groups instead of SQL Logins. One item that was not explicitly addressed that you mentioned is...
March 28, 2012 at 2:55 pm
GilaMonster (3/28/2012)
opc.three (3/28/2012)
I do not have the luxury of creating every index ever added to databases in the instance.
Neither do I. What I do is log index fragmentation and...
March 28, 2012 at 2:38 pm
Please direct all replies here:
http://www.sqlservercentral.com/Forums/Topic1274667-391-1.aspx
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...
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...
March 28, 2012 at 1:58 pm
Tools > Options > Environment > General > Open Empty Environment
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...
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...
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...
March 28, 2012 at 1:27 pm
Maxer (3/28/2012)
When I right click on the table and go to Design it...
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...
March 28, 2012 at 1:18 pm
Abdul Walele (3/28/2012)
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...
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.
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...
March 28, 2012 at 12:28 pm
Viewing 15 posts - 4,726 through 4,740 (of 7,168 total)