Viewing 15 posts - 181 through 195 (of 490 total)
SQLRNNR (9/1/2011)
Looks like just the tools upgraded and not the database engine.
More likely the other way around since sqlservr.exe version shows 4035.
Leo
September 1, 2011 at 3:48 pm
Was this working an now suddenly not working? And on only some work stations?
I know there were issues with WinXP after some service packs that disabled the AxtiveX control in...
August 29, 2011 at 7:18 pm
Jeffrey Williams-493691 (8/20/2011)
August 21, 2011 at 2:38 pm
GilaMonster (8/18/2011)
but Standard Edition will never use more than 4 cores in total.
Can you point me to a document on this? I'm not convinced that standard can only...
August 18, 2011 at 1:30 pm
SQLRNNR (8/17/2011)
You have 2 sockets and 8 processors.
Except if you licence Per Processor, you only pay for 2 licences, not 8.
This took me for ever to get my head around.
Leo
August 17, 2011 at 2:03 pm
If you look at how many processors SQL sees, you will see it says 8. If you want to set MAXDOP to try elliminate the CXPacket waits then 1 is...
August 17, 2011 at 2:01 pm
Did you review the scripts before you ran them? Did they look correct?
Also after you ran the scripts where there any errors reported.
There are a few things that can go...
August 17, 2011 at 1:54 pm
jprovines (8/15/2011)
August 15, 2011 at 5:35 pm
What time does the restore job run? At the same time as the backup job?
It would be interesting to change the time and see if this changes the deleted files...
August 15, 2011 at 4:30 pm
jprovines (8/15/2011)
backup_source_directory\\lap8db03\TransactionLogBackupbackup_destination_directory\\lap8ea03\TransactionLogShippingTemp
file_retention_period2880
Are both of these folders being cleared after 2 days? If not which one is being cleared?
Leo
August 15, 2011 at 4:18 pm
You don't want to have both nodes active when installing the service pack. Usually you would go to Active/Pasive, then remove the pasive node from the cluster.
I would stick to...
August 14, 2011 at 3:26 pm
Like a maintenance task set to delete old tran log backups older than 3 days 🙂
Leo
August 11, 2011 at 9:24 pm
Ninja's_RGR'us (8/10/2011)
Leo.Miller (8/10/2011)
select * from Test1 with (nolock) where ID_Col = 10
But I would consider this a bit...
August 10, 2011 at 3:26 pm
Another solution would be to set all the queries to use WITH (NOLOCK)
select * from Test1 with (nolock) where ID_Col = 10
But I would consider this a bit of a...
August 10, 2011 at 3:12 pm
krypto69 (8/10/2011)
intersting Leo....can you elaborate?
Yes.....
But I assume you want more than this..:-)
On one connection do the update - This was my test
begin tran
update Test1 set First_Name = 'Test1' where ID_Col...
August 10, 2011 at 3:07 pm
Viewing 15 posts - 181 through 195 (of 490 total)