Viewing 15 posts - 76 through 90 (of 930 total)
MSQLDBA (5/5/2012)
Hi Friends,So can anyone suggest me how i can restrict users to access database.
Mirrored database as such is not accessible.
May 5, 2012 at 10:15 pm
Sapen (4/30/2012)
If upgrading the OS to Enterprise edition is the only solution then I am sure it is wasted (budget constraints).
What would be the implications on SQL Server when the...
April 30, 2012 at 8:29 pm
Didn't know about the answer, googled it 🙂
April 26, 2012 at 11:48 pm
eric.lyons (4/20/2012)
1) drop the replication and recreate from scratch.
2) set up a purge job in the system distribution db.
I...
April 20, 2012 at 11:15 am
Minto Minto(quendans) (4/20/2012)
Before the job please find the row count of MSrepl_commands
Row count:4658791
After ...
April 20, 2012 at 8:27 am
and the default 4K allocation unit (instead of 64k), both of which could cause a single logical read to become multiple physical reads.
Is it possible to check the allocation...
April 20, 2012 at 7:25 am
Good Job. Thanks for sharing your experience on this performance issue.
April 20, 2012 at 2:30 am
April 19, 2012 at 10:53 pm
Please clarify on question
April 19, 2012 at 5:39 am
Viewing 15 posts - 76 through 90 (of 930 total)