Viewing 15 posts - 38,371 through 38,385 (of 49,552 total)
CXPacket wait is a CPU-related wait, not an IO-related wait. It's from queries processing in parallel. There's a number of things that can cause that, from poor statistics (SQL makes...
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 17, 2009 at 10:14 am
That's a table variable and, other than unique constraints, it can't be indexed.
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 17, 2009 at 9:30 am
The other immediate problem is this
if update(FA_codefamille)
begin
update F_article
set AR_Prixach=@dl_montant
end
That will update the entire table with the value in @dl_montant because there's no where clause on the update.
I think you're going...
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 17, 2009 at 9:10 am
Chris (6/17/2009)
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 17, 2009 at 8:56 am
The first problem with this trigger is that it's assuming there's only one row in the inserted table. If more than one row is affected by an insert/update, the trigger...
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 17, 2009 at 8:54 am
Read uncommitted only affects reads, that is selects. Data changes will always lock. Also, be aware of what read uncommitted actually is. See - http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx
I would suggest having a look...
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 17, 2009 at 7:48 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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 17, 2009 at 7:43 am
sagi (6/16/2009)
plz send code very urgent thn'ssssssss
Show us what you have so far. I'm happy to help, but not to do the entire job for you.
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 17, 2009 at 7:43 am
A CXPacket wait is due to a parallel skew. SQL has decided it will parallel one or more operators in a query and one of the threads finishes before 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 17, 2009 at 7:40 am
Have you looked at SQLCMD? It's the replacement for osql which itself was the replacement for isql.
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 17, 2009 at 7:35 am
SAT_SQL (6/17/2009)
that trace is running for , for suppose i am having one procedure name...
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 17, 2009 at 7:31 am
Paul White (6/17/2009)
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 17, 2009 at 7:31 am
Paul White (6/17/2009)
GilaMonster (6/17/2009)
In all cases that have been observed.Maybe not 😉
Weren't you the one who said earlier in this thread that you'd never seen an update that didn't work...
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 17, 2009 at 7:28 am
Florian Reischl (6/17/2009)
Just tried on SQL Server 2000. ESCAPE works fine 😉
I was going to say...
I know I've used ESCAPE on SQL 2000 before...
http://msdn.microsoft.com/en-us/library/aa933232(SQL.80).aspx
LIKE:
Syntax
match_expression [ NOT ] LIKE pattern...
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 17, 2009 at 7:25 am
Poor performance. Generally that kind of query does not use indexes effectively and often does table scans. On small tables that aren't used too often that won't be a major...
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 17, 2009 at 1:33 am
Viewing 15 posts - 38,371 through 38,385 (of 49,552 total)