Viewing 15 posts - 20,176 through 20,190 (of 49,552 total)
It is a very old command, it's still there and still usable (though I prefer the function version if I'm delving into the log), it's just not that easy to...
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
February 21, 2012 at 12:48 pm
SQLKnowItAll (2/21/2012)
GilaMonster (2/21/2012)
A seek is not better than a scan. Forcing a seek with something like...
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
February 21, 2012 at 12:47 pm
EL Jerry (2/21/2012)
In your experience, how often have you seen DBs with Bulk-Logged recovery models and what are they used for?
A couple, but I suspect that was due to lack...
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
February 21, 2012 at 12:46 pm
My guess is he's looking for the undocumented DBCC DBLOG, not that I would ever choose to use that to see what's causing log growth, it's not intended to be...
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
February 21, 2012 at 11:11 am
No offence intended, but from what you've said that sounds like a completely wrong approach.
A seek is not better than a scan. Forcing a seek with something like WHERE Column...
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
February 21, 2012 at 11:09 am
If you're on standard edition, rebuilding indexes is an offline operation always, for a nonclustered index rebuild the table will be read-only for the duration, for a clustered index rebuild...
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
February 21, 2012 at 10:43 am
Reorganise is an online operation, if you're on Enterprise Edition you can rebuild the indexes online
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
February 21, 2012 at 10:37 am
This is a Microsoft SQL Server forum and we assumed, since you're posting on a SQL Server forum, that you are using SQL Server not MySQL. Maybe http://dbforums.com or http:/forums.mysql.com...
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
February 21, 2012 at 10:24 am
If a front end makes an RPC call to execute procedure 1 and procedure 1 calls procedure 2, then only procedure 1 appears as an RPC event, both will appear...
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
February 21, 2012 at 10:03 am
sestell1 (2/21/2012)
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
February 21, 2012 at 8:17 am
SqlMel (2/21/2012)
It's now down to 2% 🙂
Nils Gustav Stråbø (2/21/2012)
I'm surprised that 21% believes that you can do a point in time restore of...
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
February 21, 2012 at 6:18 am
Heaps or maybe LOB columns in tables (they're a pain for the shrink operation to handle)
Shrink in chunks sometimes works better than one huge (and certainly gives at least the...
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
February 21, 2012 at 5:56 am
Detach, yes. Reattach, probably not.
Considered restoring WITH STANDBY?
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
February 21, 2012 at 5:54 am
What would be the point? Log shipping is for high-availability, protection against server failure or hardware failure. If both instances are on the same server, there's no gain.
For testing/practice, sure,...
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
February 21, 2012 at 5:52 am
I can't even make a wild guess with this little information. If you want help, you need to give us something to work with.
What wait type?
What wait resources (if...
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
February 21, 2012 at 4:40 am
Viewing 15 posts - 20,176 through 20,190 (of 49,552 total)