Viewing 15 posts - 916 through 930 (of 4,745 total)
having applied SP2 you certainly wouldn't apply CU6,7,8 for SP1, they wouldn't apply anyway as they are previous to SP2.
What MS do is bring out a CU1 for the latest...
September 11, 2012 at 4:29 pm
sounds like an explorer display issue rather than a sql issue, so I dont think you have a problem here, especially as they cycle OK..
In explorer in organize view is...
September 11, 2012 at 11:50 am
read the blog from paul randal anthony posted and check out the scripts it links to which determine if you have tempdb contention. If you have no latch contention on...
September 11, 2012 at 3:11 am
<sigh> were the auditors dbas?
thats a rather blanket recommendation, and there are lots of other recommendations than one file per core.
The recommendation should be that if you are not using...
September 11, 2012 at 2:45 am
nice reminder, thanks. Good to hear the table only has one clustered index! 🙂
The points in the link about logging behaviour when you batch up bulk imports are important to...
September 11, 2012 at 2:26 am
if you just need to know who is in what database role use this
SELECT 'EXEC sp_addrolemember [' + dp.name + '], [' + USER_NAME(drm.member_principal_id) + '] ' AS [-- AddRolemembers]
FROM...
September 7, 2012 at 2:54 pm
L' Eomot Inversé (9/4/2012)
george sibbald (9/4/2012)
On the subject of pronunciation I would like to make it clear that we look after d-ay-tabases, not d-ar-tabases🙂
I can't imagine anyone saying d-ar-tabases, but...
September 4, 2012 at 5:16 pm
On the subject of pronunciation I would like to make it clear that we look after d-ay-tabases, not d-ar-tabases
🙂
September 4, 2012 at 1:48 pm
In SQL2005 a restore of any database in an instance caused the proc cache to be flushed, this would lead to a peformance hit. You would see messages to that...
September 4, 2012 at 1:39 pm
even if you back the log up to the same location as the log shipping backups it will still break log shipping as it will not be reflected in the...
August 27, 2012 at 3:35 pm
you don't need any other log backups than the log backup job created by logshipping. Indeed, if you take other log backups it will break logshipping.
The log backup taken by...
August 25, 2012 at 1:11 pm
with sql server 2008 there is a back door, if you have admin on your machine you can start sql server in single user mode and then add an account...
August 25, 2012 at 8:29 am
use the rolling upgrade method -
August 21, 2012 at 7:47 am
Viewing 15 posts - 916 through 930 (of 4,745 total)