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."
http://www.sqlservercentral.com/Forums/FindPost889310.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 24, 2010 at 1:40 pm
Maybe
A 25000 row table with no indexes at all is going to perform badly, because the only way to find a row is to read all 25000 rows.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 24, 2010 at 1:38 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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......
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 24, 2010 at 6:42 am
Table and index definitions please
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 24, 2010 at 6:38 am
Viewing 15 posts - 33,331 through 33,345 (of 49,552 total)