Viewing 15 posts - 5,431 through 5,445 (of 9,244 total)
durai nagarajan (6/21/2012)[hrIn our environment we have two domain users one for SQL services and another for cluster.
i am planning to revoke the access and configure the same with SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 25, 2012 at 12:45 am
whichever way you look at it your disk config is limiting, as is the RAM capacity.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 24, 2012 at 3:28 pm
Anthony is spot on here, all communications are essentially triggered from the secondary server. Just a note to bear in mind, the backup folder for the primary server does not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 21, 2012 at 8:12 am
Are the mirroring instances on the same server or separate servers? Have you checked the mirror endpoints status?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 21, 2012 at 8:12 am
Michael Valentine Jones (6/20/2012)
execute sp_updatestats
sp_updatestats (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms173804(v=sql.105).aspx
"...sp_updatestats updates only the statistics that require updating based on the rowmodctr...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 21, 2012 at 8:02 am
Roust_m (6/20/2012)
Perry Whittle (6/20/2012)What on earth makes you think that? It's no different to any other node failure in a cluster, the instance will restart on a partner node. Where...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 21, 2012 at 12:45 am
at what point is the installation at, are there any services installed?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 3:38 pm
sqlbee19 (6/20/2012)
Perry - Thanks for your response.I am using sysindexes table because of column "rowmodctr" is only available in sysindexes.
That is correct, remember though that sysindexes is provided for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 2:46 pm
ran.ovadia (6/20/2012)
I currenty have in my Prod env. SQL2005 SP3 + GDR (9.0.4053) and in test env I have SQl2005 + Sp3 (9.0.4035).
Now i need to upgrade my Test env...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 8:04 am
Welsh Corgi (6/19/2012)
I'm sorry I misread it.It is MB not GB.:blush:
I have been working a lot of hours and I'm tired and it's only Tuesday.
Thanks for the information!
🙂 it's even...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 7:57 am
The master key has absolutely nothing to do with moving the database!
You need a backup of the certificate and its password and the database backup itself. The master key merely...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 7:44 am
Roust_m (5/9/2012)
I want to define a policy to make sure every table and every index (including those for indexed views) in the database has "PAGE" compression.
I could only find a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 7:36 am
the cluster will replicate this change for you, just apply at the active node
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 7:32 am
sqlbee19 (6/19/2012)
FROM dbo.SYSINDEXES SI (NOLOCK)
INNER JOIN SYS.OBJECTS T ON T.object_id = SI.[id]
Instead of using sysindexes, use sys.indexes and sys.objects
The first thing you want to do is to get...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 7:30 am
what do the jobs actually do??
Try setting the log output on the job steps to get more info too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 7:21 am
Viewing 15 posts - 5,431 through 5,445 (of 9,244 total)