Viewing 15 posts - 38,746 through 38,760 (of 49,552 total)
vikas bindra (6/2/2009)
Do I actually need NIX_WITHINCLUDE_1 and NIX_WITHOUTINCLUDE indexes?
I can't see any reason why you would. It is possible that SQL would use the smaller ones occationally, but 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
June 2, 2009 at 3:57 am
vidhyasudha (6/2/2009)
First I create a temp table to hold the data that satisfy the where conditionINSERT INTO #tmpP
select x.p_id, x.col1,x.col2,x.col3 from x where x.colm4 'N'
What is table x?
set @pidentity...
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
June 2, 2009 at 3:55 am
Yup. The setting is 'max degree of parallelism'. If it's 0, SQL will use as many of the CPUs as it feels necessary for a query. If you set 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
June 2, 2009 at 3:48 am
Do you mean SQL Server 2005? There is no version 2003.
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
June 2, 2009 at 3:47 am
rafidheenm (6/2/2009)
This can be write like this and avoid CASE statements from WHERE clause..
Yes, but it doesn't change the execution characteristics. Just like the case statement version, that will typically...
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
June 2, 2009 at 3:39 am
sql_lock (6/2/2009)
IF(UPDATE(Authorised))
That trigger is not going to do anything for the update you posted. It will only execute if the Authorised column is updated, that's what the IF UPDATED line...
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
June 2, 2009 at 3:38 am
In 2008, SQL can 'repair' damaged pages from the mirror automatically. Enterprise edition only.
Books Online:
A database mirroring partner running on SQL Server 2008 Enterprise or later versions automatically tries 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
June 2, 2009 at 2:10 am
It is about permission. Only the connection that created a temp table can drop it.
See if you can run sp_spaceused on that table and see how much space it's taking...
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
June 2, 2009 at 1:49 am
GURSETHI (6/1/2009)
slow performance?
A: Sleeping means waiting for a event 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
June 2, 2009 at 1:34 am
Is there code in the trigger to check that a row has actually changed?
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
June 1, 2009 at 2:39 pm
TRACEY (6/1/2009)
Is this total or per DRIVE DISKS...to select.
Individually for each drive that has SQL data or log.
Taking the total's not very useful as more idle drives can skew 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
June 1, 2009 at 2:30 pm
mathieu_cupryk (6/1/2009)
Msg 4104, Level 16, State 1, Procedure sprGetAffectedServicesByTicketID, Line 8The multi-part identifier "tbl_lookup_type_services.ServiceType" could not be bound.
Take a look at my query, take a look at yours. There's a...
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
June 1, 2009 at 10:41 am
Generally we don't answer interview questions here. Interviews are for you to show what you know, not for you to memorise other people's answers. Some of those questions are fairly...
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
June 1, 2009 at 10:40 am
Are those drives set up as dependencies in the cluster?
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
June 1, 2009 at 10:35 am
I don't understand your question. If there's a cross join it's because either you typed CROSS JOIN or, if you used a query builder, because you didn't define a relationship...
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
June 1, 2009 at 10:33 am
Viewing 15 posts - 38,746 through 38,760 (of 49,552 total)