Viewing 15 posts - 1,051 through 1,065 (of 2,462 total)
anthony.green (7/22/2011)
under registered servers --> database engine --> central management servers
add in your central server, then register any child servers under the central...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 22, 2011 at 1:17 am
ALZDBA (7/21/2011)
- are your cpu-cores dedicated or do all instances compete for all cores ?
we dont have dedicated CPUs
ALZDBA (7/21/2011)
- what kind of io system / layout is in use...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 21, 2011 at 3:27 am
Sorry i forgot to tell the memory distribution
instances :
1st : 2 gb
2nd : 2 gb ( mirrored from 1st)
3rd : 2 gb
4th : 2 gb...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 21, 2011 at 2:16 am
no , before shutting down the sql server, check point will be raised that will flush dirty data and log pages from the buffer cache of the current database.So you...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 13, 2011 at 6:12 am
have you tried xp_cmdshell command, is it working ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 13, 2011 at 6:07 am
gsuvarnarekha (7/4/2011)
Could any body tel me what are the steps to enable sql profiler and to check whether its enable or not.
i think this is knowledge gathering question if...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 5, 2011 at 5:44 am
Are you using any job to refresh the snapshot ? if yes then you can the schedule
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 5, 2011 at 5:41 am
halifaxdal (7/5/2011)
I want to then remove the oldest version when making newer backup, so the bak is always 4 version size and always keeps a month history.
this statement is...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 5, 2011 at 5:34 am
koustav_1982 (7/4/2011)
1.The index at the end , in the last few pages of a Dictionary serves as the nonclustered index.
Yes , its called biblography(indexing)
koustav_1982 (7/4/2011)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 4, 2011 at 5:23 am
Syed Jahanzaib Bin hassan (6/30/2011)
Are you using Named Instance ?
Yes
Syed Jahanzaib Bin hassan (6/30/2011)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 30, 2011 at 1:53 am
A lot of area ,which can be get affected like CPU, IO usage, Log size , there might be blocking.
my take would be to do the deletion in batches...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 30, 2011 at 1:22 am
"\etworklocation\"
Check above location is accessible locally from where the backup has been taken ? OR is there any recent change in permissions?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 28, 2011 at 4:35 am
Additionally, we can have a stored proc with parameters ( where clause conditions) and handle the other restriction like "no of rows need to be updated" or we can handle...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 27, 2011 at 6:56 am
i ran the above query against all system db nit no luck
and
below is the figures of tempdb in (MB)
USED (%)26.90 (7.68 %)
FREE (%)323.55 (92.32...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 22, 2011 at 6:56 am
i am using sql 2005 sp3 and database is in simple recovery model
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 22, 2011 at 6:49 am
Viewing 15 posts - 1,051 through 1,065 (of 2,462 total)