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...
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...
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...
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...
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...
October 7, 2013 at 4:49 am
Dont cross post ...
Post the replies at http://www.sqlservercentral.com/Forums/Topic1502072-1351-1.aspx
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 ?
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...
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,...
October 7, 2013 at 4:07 am
clucasi (10/4/2013)
October 7, 2013 at 4:05 am
Jeff Moden (10/6/2013)
Truly good DBAs are hard to find.
+100000000000
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...
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...
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.
October 7, 2013 at 2:58 am
aren't
the statistics outdated ?
October 4, 2013 at 9:51 am
Viewing 15 posts - 166 through 180 (of 2,462 total)