Viewing 15 posts - 34,996 through 35,010 (of 49,552 total)
That's the SQL startup routine.
The error log has the latest events at the beginning and the oldest at the end.
Just after it stops, look for the file ERRORLOG.1 That...
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
January 5, 2010 at 5:32 am
Bhuvnesh (1/5/2010)
my senior DBA suggest thatwe should avoid this left join
Then ask him why and how he suggest going about it.
It doesn't make any sense to say...
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
January 5, 2010 at 5:31 am
Why do you want to remove the second left join? What's wrong with the query as-is?
If you want that rewritten, you're going to have to give us a bit more...
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
January 5, 2010 at 4:30 am
That doesn't look like the SQL Server error log. It looks like the SQL Agent log, which is not going to gove anything useful regarding teh SQL service itself.
I'm asking...
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
January 5, 2010 at 4:28 am
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC TRACEON(1222,-1)
Block...
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
January 5, 2010 at 12:00 am
How big are those indexes? (how many pages)
Heaps, clustered index or nonclustered index?
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
January 4, 2010 at 11:56 pm
X is an exclusive lock and U is an update lock. Neither will be taken by a select unless there is a locking hint.
Can you post the entire deadlock graph?
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
January 4, 2010 at 11:55 pm
Please post new questions in a new thread in future.
If you look while the query is running, there will be at least one thread that doesn't have a cxpacket, that...
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
January 4, 2010 at 11:53 pm
Dave Ballantyne (1/4/2010)
Read it , understand it , practise it , pass the exam and its as simple as that
You left out "pay for it, attend the 4 weeks of...
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
January 4, 2010 at 2:35 pm
There's enough information around for indexing strategies and the like. My blog's got some, all of the books I mention have lots on that. That's not what I'd call deep...
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
January 4, 2010 at 9:36 am
What's about unique indexes? Do you want to drop those as well?
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
January 4, 2010 at 9:19 am
You don't need the distinct in the outer query.
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
January 4, 2010 at 9:03 am
What's the last three entries in the SQL error log?
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
January 4, 2010 at 8:53 am
And previous backups? You know, the ones you've been taking on a daily or weekly basis since you became responsible for this database?
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
January 4, 2010 at 8:51 am
Query sys.procedures and use the OBJECTPROPERTY function with the 'IsEncrypted' property.
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
January 4, 2010 at 8:49 am
Viewing 15 posts - 34,996 through 35,010 (of 49,552 total)