Viewing 15 posts - 6,121 through 6,135 (of 49,571 total)
andrew gothard (4/20/2015)
April 21, 2015 at 2:26 am
You're probably looking for transactional replication here.
Log shipping and mirroring are HA/DR technologies, hot standby databases for when/if the primary fails.
April 21, 2015 at 2:22 am
Error logs have their own built-in retention, transaction logs you don't delete at all. Specifically what logs are you talking about?
April 21, 2015 at 2:19 am
Altering a table (including dropping an FK) requires a schema modification lock. Schema mod locks are not compatible with any other locks at all, and hence you need a short...
April 21, 2015 at 2:17 am
yb751 (4/20/2015)
April 20, 2015 at 10:03 am
Jeff Moden (4/20/2015)
GilaMonster (4/20/2015)
The default trace does log temp table creates and drops.Awesome!
Not usually. 🙂
It's one reason why the default trace sometimes covers such a short time period. Personally...
April 20, 2015 at 9:52 am
TheSQLGuru (4/20/2015)
April 20, 2015 at 9:34 am
It's an allocation page, it doesn't belong to a specific object. In this case, it's a GAM page (Global allocation map) which tracks which extents are allocated and which are...
April 20, 2015 at 9:16 am
andrew gothard (4/20/2015)
Not that I've ever tried it, but I'd expect snapshotting an active 2Tb database could take a real bite out of my maintenance window.
Shouldn't do. If there...
April 20, 2015 at 9:13 am
SQL's not going to struggle to rebuild indexes with GUIDs in them, uniqueidentifiers are no harder to work with than strings, and probably are easier. The problem is that GUIDs...
April 20, 2015 at 7:33 am
suvorav (4/20/2015)
1. How to estimate how many free RAM I need.
https://msdn.microsoft.com/en-us/library/dn282389.aspx
2. How to prevent memory overflow if there will be too much data in those tables?
SQL won't allow...
April 20, 2015 at 7:29 am
MotivateMan1394 (4/19/2015)
I was thinking about it and Found that in any Steps of my partitioning I didnt use this table name????
1- Create New FG
2- Create New Files And related them...
April 20, 2015 at 7:05 am
https://support.microsoft.com/en-us/kb/246133
sp_help_revlogin moves logins and passwords, that's it. A later option in that kb article does roles as well.
April 20, 2015 at 6:29 am
Call Microsoft Customer Support. Number should be somewhere on Microsoft's web site.
April 20, 2015 at 4:17 am
Viewing 15 posts - 6,121 through 6,135 (of 49,571 total)