Viewing 15 posts - 6,121 through 6,135 (of 49,552 total)
andrew gothard (4/20/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 21, 2015 at 2:17 am
yb751 (4/20/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2015 at 9:52 am
TheSQLGuru (4/20/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2015 at 7:05 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2015 at 6:41 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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2015 at 6:29 am
Call Microsoft Customer Support. Number should be somewhere on Microsoft's web site.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2015 at 4:17 am
Viewing 15 posts - 6,121 through 6,135 (of 49,552 total)