Viewing 15 posts - 1,261 through 1,275 (of 2,462 total)
declare @time datetime, @addition int
set @time = '2010-09-29 11:53:00'
set @addition = 1
select dateadd( hh, @addition,@time)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 29, 2010 at 3:53 am
if you dont get data in this DMV then trace flag 2330 could be enable at this sql server. flip it to OFF and then your DMV will capture...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 28, 2010 at 5:10 am
Mark Salvador (2/5/2009)
I tried looking for missing index and I used this query:
but why are you looking for indexes in this DMV. ? did you get any bad...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 28, 2010 at 5:08 am
there are couple of books available here http://www.sqlservercentral.com/Books/ above of this i would say use "GOOGLE".
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 27, 2010 at 6:24 am
Try to keep almost similar config as you have on prod ...you can compromise with disk , CPU etc.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 27, 2010 at 6:22 am
JStevenson1 (9/25/2010)
one of the question I am trying to answer is "How do I know they are who they say they are?".
login/username are provided by the admin( who...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 27, 2010 at 1:47 am
If you can afford dirty reads then use with nolock
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 27, 2010 at 12:59 am
Tara-1044200 (9/26/2010)
so that i can keep all the statistics created before the restore to improve my query performance.
i dont think that can be done, statistics(not the user defined ones)...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 27, 2010 at 12:49 am
Tara-1044200 (9/22/2010)
the Bad databse could not use parallelism not sure why though it is very small
Parallelism depends on the amount of the data dealt in a query execution( when...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 27, 2010 at 12:47 am
Yes group by could be reason for heavy reads.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 24, 2010 at 3:29 am
What is the name of that SP?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 24, 2010 at 1:27 am
ricardo_chicas (9/23/2010)
on a diferent db I ran that query and one of the results says this:name_______impact_____________seeks_ scans_equalitycolumn_inequalitycolumn___included
table1______229918.581387738___2080___0____[pronumber]___NULL_____________NULL
i am not aware of these things ..may be gail can comment on...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 23, 2010 at 10:43 pm
Jack Corbett (9/23/2010)
Bhuvnesh (9/22/2010)
Jack Corbett (9/22/2010)
Foreign Keys are not indexesbut i think, by default it gives non-clustered index.
Nope. A foreign key does NOT create an index of any kind.
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 23, 2010 at 5:12 am
Few things :
1.take help of sp_lock and sp_who2, and see if you can find/trace some suspect spid.
2.Any backend process/job at the same time.
3.read the errorlog
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 23, 2010 at 3:51 am
post table and index definition along with exec plan.See only the query cant give good/appropriate hint/suggestion
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 23, 2010 at 3:48 am
Viewing 15 posts - 1,261 through 1,275 (of 2,462 total)