Good. Is that normal? In other words, do you see those WRITELOG waits all the time, or only while the system is running slow?

John

It could be, but until you capture the wait stats, you're just speculating. Also, see whether you can capture sys.dm_os_waiting_tasks during that single second of slowness. If you...

You might want to capture wait stats as well. Since they're cumulative since SQL Server started, you'll need to subtract one set of figures from the next in order...

If you want the trigger to update those columns regardless of which columns are updated, just remove the IF clause altogether.

John

What is the data type of the Acc column? If it's not varchar(20), there may be some conversion going on. Please will you post the execution plans?

John

Does this happen every time, even after you clear the plan cache (don't do that on a production server, though)? Have you compared the execution plans for the two...

pbo71465 (4/1/2016)

---

...as long as I didn't go beyond a certain range of Prime Numbers, the sum of these numbers would always be different.

The only problem was there is the possibility...

Eamon

Is there not an option in the Flat File Connection Manager in SSIS to overlook any delimiters that are enclosed in quotes? If not, I can't think of any...

I don't know whether this is the most efficient way, but you could use bitmasks. In a separate table, assign a power of two to each action, for example...

The clustering key is the column, or set of columns, on which you choose to create your clustered index.

Where did you read the term "heap index"? A table without...

If you just want to find rows where query_plan contains those terms, convert to varchar(max) and use LIKE, CHARINDEX or PATINDEX. If you want to know where in the...

Strictly speaking, it isn't. A unique index can allow NULL...

That's only going to show the permissions he or she has on [dbo].[StoredProcedureName]. Try removing the first line of your WHERE clause and see what you get then.

Is this...

Yes. In Example 1, you've got the extra expense of compiling the query because it's more complex (it involves a join), and also of actually retrieving the values from...

select * from RS_Patient_6

where MyDatabase.MySchema.PatientID_6_660 = ‘<patient id>’

John