Viewing 15 posts - 61 through 75 (of 355 total)
Probably something to do with this part:
EXECsp_addmergepartition
does a merge partition require a dynamic filter?
March 21, 2016 at 3:23 pm
What's your server power options set to?
Found this via google pretty quick too:
Performance Problems with SQL Server 2012 Enterprise Edition Under CAL Licensing
March 21, 2016 at 3:04 pm
If you leave your databases in full recovery without transaction log backups, you will eventually have problems as the transaction log will grow continuously.
How many databases did you setup log...
March 21, 2016 at 3:02 pm
I've heard of others setting up jobs on a third server, pointing at the listener.
March 21, 2016 at 3:00 pm
1. Test it out
2. I would be shocked if a new install overwrote your pre-existing, patched, shared features.
3. Patch as part of your new installs
You could also take advantage of...
March 21, 2016 at 2:54 pm
Is there any additional information in the default trace?
March 21, 2016 at 2:50 pm
The really cool part about standards is... there are so many of them.
:laugh:
March 21, 2016 at 2:49 pm
March 21, 2016 at 2:29 pm
check the collations
March 21, 2016 at 2:20 pm
You could also track it down / prevent the change via Login Triggers:
CREATE TRIGGER [alter_login]
ON ALL SERVER
FOR ALTER_LOGIN
AS...
[Send yourself an email including who tried to change it]
March 21, 2016 at 2:19 pm
Meta LUNs are used to expand an existing LUN, each time space is required a new LUN is created and added to the meta LUN config
That, AND it's the striping...
March 16, 2016 at 1:23 pm
You can add indexes to the readable side if you use replication.
March 16, 2016 at 9:39 am
Do you know if you're using MetaLUNs on the SAN?
March 16, 2016 at 9:31 am
Check this (first google result):
http://www.sqlservercentral.com/Forums/Topic1156421-391-1.aspx
March 16, 2016 at 9:17 am
You could use snapshot replication and just snap the data, not the stored procs...
Specify Article Types (Replication Transact-SQL Programming)
March 16, 2016 at 9:13 am
Viewing 15 posts - 61 through 75 (of 355 total)