CELKO (11/7/2014)

---

>> I have the following Games table: <<

This kind of problem shows up too often to be real. What school is using this as homework? We need to find...

First, check for RAM pressure/bottlenecks. If you have (way) too little RAM, nothing else you do will matter much.

Then check for I/O pressure/bottlenecks.

Finally look for CPU pressure/bottlenecks. These...

Fillfactor 0 is potentially extremely dangerous to performance, and can be very prone to fragmentation, esp. on a table where it's common to lengthen [n]varchar column(s).

I also noted above that...

1)

That's pretty low. How did you decide on that? You really need to tailor for each table's situation and not just apply a low...

My guess is it's just some quirk with the output clause and ROW_NUMBER(), because the expected row gets kept even when the OUTPUT seems to indicate otherwise:

declare @t table (a...

If possible, you want to specify contiguous clustered key ranges on the main/larger table to UPDATE. You only want to each affected block of that table one time.

If you (almost) always provide created_date in the WHERE clause when querying that table, change the clustered index on the table to be on created_date. That will 100% solve...

Those queries themselves are relatively trivial. You'll sort that out quickly.

But the clustering index is the most critical overall factor in performance and two tables need changed. Without...

FWIW, sure potentially sounds to me like homework or the equivalent.

I don't know exactly how you want to order the results, but something like this should do what you want:

SELECT

ol.OrdNo, ol.ProdNo, ol.Descr,ol.DPrice, pr.PictNo, pr.NoteNm as DescriptLong,

(ROW_NUMBER() OVER(ORDER BY ol.OrdNo,...

You can use CROSS APPLY to assign alias names to expressions:

select distinct top 100 filedate, transaction_date, duedate,

event_instance, event_name, eventstatus, age,

DaysAged,

coalesce (DaysAged, new, 0) as aged

from...

Best is to always strip non-numeric chars before storing the value. If you have to, store both the original, edited version and a stripped version, or, better yet, a...

Does that user/login also exist in prod? If so, the SIDs of the prod login and the nonprod login are different. If you want the user to work...

GilaMonster (10/29/2014)

---

ISNULL (IntegerColumnName, ReplacementValue)

The data type returned will be the 'larger' of INT and whatever the replacement value is.

btw, SQL doesn't have booleans. It has the bit data type which...

I think this is the general structure you need:

SELECT p.*, d_outer.date

FROM Project p

INNER JOIN Date d ON

p.ProjectID = d.ProjectID

CROSS APPLY (

VALUES(d.Date1),(d.Date2),(D.Date3) /*,...,D.Date20*/

)...