Viewing 15 posts - 166 through 180 (of 2,462 total)
Based on the load you have mentioned here.yes i think below ratio can work.
OS - 4 GB
Named- 4/6 GB
Default -- 22/24 GB
BUt keep the memory utilization on...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 7, 2013 at 8:15 am
I strongly agree with grant and kurt here..The more we make our job AUTOMATE..more our life will be easier
AND
there is be LESS chances of "skip/fogret" chances.
Whenever, there is word...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 7, 2013 at 8:11 am
Zeal-DBA (10/7/2013)
but it does not facilitate to provide time or hours... only days can be defined.how to define time or 5 hour before in DEL\Forfiles commands
i am not comfotable...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 7, 2013 at 5:19 am
Often, The objective if Interview is bascially "not to select good DBA" but to select a person who can easily fit in the requirement and often the inerview's...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 7, 2013 at 5:16 am
Zeal-DBA (10/7/2013)
i have some error in using "sp_delete_file" Stored procedure. so looking some other option or script to delete files before 8 PM. daily. if some one can design...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 7, 2013 at 4:49 am
Dont cross post ...
Post the replies at http://www.sqlservercentral.com/Forums/Topic1502072-1351-1.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 7, 2013 at 4:47 am
nitin.varshney (10/7/2013)
I just want to know the table partiton update, not about performing the query.
Can you be more specific ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 7, 2013 at 4:44 am
curious_sqldba (10/6/2013)
Can we disable PK which is nc index?thanks
you cant disable PK infact you can drop the constraint and think how would you maintain the uniqueness
because
if duplicate...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 7, 2013 at 4:17 am
nitin.varshney (10/7/2013)
To update the table partitions, is it suffies to drop and recreate the cluster Index on that table with the new partition Schema.
When querying data or performing updates,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 7, 2013 at 4:07 am
clucasi (10/4/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 7, 2013 at 4:05 am
Jeff Moden (10/6/2013)
Truly good DBAs are hard to find.
+100000000000
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 7, 2013 at 3:58 am
Here you will find below marvelous pinches like
1) real time issue with approaches taken by people
2) some great and mind blowing solutions and explanations for #1.
3) great linked article and...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 7, 2013 at 3:55 am
baskey86 (10/7/2013)
I tried your method.but it simply through an error.Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'ALLselect'.
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'p'.
First...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 7, 2013 at 3:46 am
Try this
exec (@query + ' UNION ALL' + @query1)
but above will work of bolthh select have same columns type and count.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 7, 2013 at 2:58 am
aren't
the statistics outdated ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 4, 2013 at 9:51 am
Viewing 15 posts - 166 through 180 (of 2,462 total)