Viewing 15 posts - 33,331 through 33,345 (of 49,552 total)
Here's an interesting opinion on braindumps.
"The software complaints [about the use of braindumps] are more from the elites trying to keep people out."
March 25, 2010 at 7:12 am
repent_kog_is_near (3/24/2010)
Can you filter in profiler by tablename ( I know you can filter by database).
Typically no.
The object name column is not populated for ad-hoc SQL (T-SQL Batch completed,...
March 25, 2010 at 2:09 am
You get a mock up of some tool and asked to do some job.
That's about all I can say safely.
March 25, 2010 at 2:01 am
ande.venkat50 (3/24/2010)
hi, will you plz send me sql server dba interview questions
Different companies will ask different questions. Memorising sample questions is unlikely to help.
Advice:
Relax
Don't exaggerate your abilities.
If you don't know...
March 25, 2010 at 1:59 am
charipg (3/24/2010)
no errors in errorlog.
No messages whatsoever relating to this database? Can you post the latest error log (just zip and attach the ERRORLOG file)
March 25, 2010 at 1:59 am
Considering that this thread is almost 3 years old, I'm guessing the OP has come right somehow.
Rebuilding indexes is not a way to fix corruption. It might (read might) make...
March 24, 2010 at 1:40 pm
repent_kog_is_near (3/24/2010)
Do you take the missing_index_details recommendation at face value,
Never.
or do you always dig up the query for which the reco is made, and then analyze the above scenarios...
March 24, 2010 at 1:33 pm
m_p_weber (3/24/2010)
select o.name as owner from sysobjects o with (nolock) inner join sysusers u with (nolock) on o.uid = u.uidwhere u.name = 'username'
Those are both deprecated system objects included...
March 24, 2010 at 10:07 am
mazzz (3/24/2010)
I see lots of objects created with names like _WA_Sys_...... which must be legit/system generated.
Auto-generated statistics
March 24, 2010 at 9:23 am
Diskeeper may well be the cause of the problem.
http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/12/29/diskeeper-2010-update.aspx
p.s. Please in future post new questions in a new thread rather than resurrecting an 8 year old thread.
March 24, 2010 at 9:22 am
r.dragoi-1095738 (3/24/2010)
We have some data warehouse applications and some tables which are not indexed etc , in such cases we use it.
Um..... ok......
March 24, 2010 at 8:08 am
r.dragoi-1095738 (3/24/2010)
In my own query I had a few more tables, but it can used just like I said OPTION (Recompile)
Still begs the question, why are you forcing hash joins?
March 24, 2010 at 7:34 am
I don't care much where the PASS Summit is. I've done checks and comparisons and it's at most a difference of 2 hours travel and about $100 for various cities.
Somewhere...
March 24, 2010 at 6:42 am
Viewing 15 posts - 33,331 through 33,345 (of 49,552 total)