Randolph Potter (6/17/2009)

---

To be honest, I wouldn't be surprised if there's a lot of table scanning happening. Some of the big stuff is dynamically generated. I wanted to run Profiler...

Florian Reischl (6/17/2009)

---

@Jeffrey:

Erm... Just played with this nullbuster. This might be an important information for you:

This feature works find on SSE2k5 but it does not work anymore on SSE2k8 for...

If it's OLTP I'd consider dropping the MAXDOP to 4 or even 2. Combine that with optimising the worst offending queries, and you may get this under control fairly well.

Yes. Temp tables have a name in TempDB that includes the name given...

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...

That's a table variable and, other than unique constraints, it can't be indexed.

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...

Chris (6/17/2009)

---

Gail, I sent you a private message, but maybe others would like to know too. What is the name of the institution/program where you're working on your Masters (if...

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...

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...

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/

Show us what you have so far. I'm happy to help, but not to do the entire job for you.

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...

Have you looked at SQLCMD? It's the replacement for osql which itself was the replacement for isql.

SAT_SQL (6/17/2009)

---

Question : i want to no what are the events are columns

that trace is running for , for suppose i am having one procedure name...