Viewing 15 posts - 24,286 through 24,300 (of 49,552 total)
Jayanth_Kurup (8/9/2011)
Oops , my mistake . I tried running Backup Log with truncate only and it didnt bring the size down.
Don't ever use that. It breaks the log chain, it...
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
August 9, 2011 at 2:05 pm
chandan_jha18 (8/9/2011)
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
August 9, 2011 at 1:56 pm
CptCrusty1 (8/9/2011)
Are you the poisonous kind of Gila Monster?
Depends what mood I'm in and how rude the questions are. Usually not though. 😀
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
August 9, 2011 at 1:31 pm
The execution plan % are based on the estimated costs, which are based on the row estimations, which are incorrect in this case.
Use profiler, use Statistics IO, use statistics time....
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
August 9, 2011 at 1:31 pm
suhailtajraja (8/9/2011)
interview
What the interviewer was trying to ask, almost certainly, was for the names of the two pseudo-tables that are visible within triggers and nowhere else.
A google search for 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
August 9, 2011 at 1:22 pm
@SQLFRNDZ (8/9/2011)
suhailtajraja (8/9/2011)
I am referring to system tables accessible from DML triggers. please name them.
SELECT * FROM sys.objects WHERE type='S'
Execute this on a any database you are reffering to...
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
August 9, 2011 at 1:21 pm
Ninja's_RGR'us (8/9/2011)
You might get more usefull help by describing the task you need to complete.
Homework, exam or interview.
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
August 9, 2011 at 1:14 pm
suhailtajraja (8/9/2011)
I am referring to system tables accessible from DML triggers. please name them.
All of the system tables (well, they're system views these days) are visible from everywhere, ad-hoc queries,...
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
August 9, 2011 at 1:13 pm
CptCrusty1 (8/9/2011)
Ok... I have a proc now:
sproc_blah (@table varchar(5), @ID int, @returned_Stuff INT OUTPUT)
HOw the...
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
August 9, 2011 at 1:05 pm
All the system tables are visible from triggers. And everywhere else.
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
August 9, 2011 at 12:59 pm
See Ninja's example.
It's not false, it's an index seek. It is validly and properly an index seek (uses the upper-levels of the b-tree to locate the start of a range...
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
August 9, 2011 at 12:21 pm
chandan_jha18 (8/9/2011)
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
August 9, 2011 at 12:04 pm
chandan_jha18 (8/9/2011)
Ninja's_RGR'us (8/9/2011)
Did you update with fullscan, if not by what %?I just ran:
exec sp_updatestats.
In other words, you did a sampled update.
Please do an update statistics with full scan on...
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
August 9, 2011 at 11:48 am
GSquared (8/9/2011)
GilaMonster (8/9/2011)
Why are you installing Enterprise edition on a client OS?Yep, I missed that in the question title. Can't do that.
It'll work (usually), but very few good reasons....
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
August 9, 2011 at 11:44 am
Why are you installing Enterprise edition on a client OS?
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
August 9, 2011 at 11:16 am
Viewing 15 posts - 24,286 through 24,300 (of 49,552 total)