Viewing 15 posts - 1,261 through 1,275 (of 2,463 total)
Search
temporary tables
in http://msdn.microsoft.com/en-us/library/ms174979.aspx and you can also use table variable.
Another useful link http://www.sql-server-performance.com/articles/per/temp_tables_vs_variables_p1.aspx and http://blogs.msdn.com/b/sqlserverstorageengine/archive/2008/03/30/sql-server-table-variable-vs-local-temporary-table.aspx
September 29, 2010 at 4:25 am
declare @time datetime, @addition int
set @time = '2010-09-29 11:53:00'
set @addition = 1
select dateadd( hh, @addition,@time)
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...
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...
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".
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.
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...
September 27, 2010 at 1:47 am
If you can afford dirty reads then use with nolock
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)...
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...
September 27, 2010 at 12:47 am
Yes group by could be reason for heavy reads.
September 24, 2010 at 3:29 am
What is the name of that SP?
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...
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.
...
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
September 23, 2010 at 3:51 am
Viewing 15 posts - 1,261 through 1,275 (of 2,463 total)