thelenj (4/16/2008)

---

Yes - clustered indexes are good for range searches, but you need to weigh all of the attributes and consequences. As of right now - you have yet...

Jeff Moden (4/15/2008)

---

Whoa... wait a minute... back the performance pony up! Let's review the facts...

1. escaleraroyal already stated that the vendor tested it in QA and it was...

I'm not sure I buy the analysis. Since the value of the clustered index is what is stored in the lower level of all of the NON-clustered indexes, something...

Jeff Moden (4/14/2008)

---

You don't need XML for this... you can just do an INSERT with the understanding that there is no real good way to return the UniqueIdentifiers to the...

Also - one more thought for you. The "triangular join" processes will tend to work well if ALL of the sequences /groups are small. However, even just one...

For what it's worth - the update method for forcing order will fall apart with a parallel plan, so don't change the MAXDOP on the test I gave you. ...

Try:

set language british

That should change your regional settings (for the given connection) to british.

I however tyhink you might need to look at the

SET DATEPART DMY

syntax instead (it will...

Greg Charles (4/15/2008)

---

Specifically, you'll need a server scoped DDL trigger for DROP_DATABASE. Btw, I think the reason you got an error while trying to create a DML trigger on...

one thought - since you have the claim number and timestamp - you've got a reasonable start at a PK you just haven't used yet. Turn that into your...

Each time I read "18 Million row cursor" in your post - there's a chill going down my spine, because that will take days to process.

Is there a way you...

Did you go through the Reporting Services config tool? You usually need to hit all of the pages in there to get it to start correctly. Took me...

move the Top 1 before the @x, as in:

declare @x as int;

select top 1 @x=col from table order by col

Assuming you check the input for SQL Injection, you could use dynamic SQL, or use a LIKE syntax to simulate this.

Example - assuming you passed in a list looking like...

Testing against a QA environment doesn't mean much if the QA environment doesn't match your set up. For all you know - their QA has 5 records in each...

By the way - that was the "interest gets applied at the END of the period" formula. For the "beginning" - it would be:

select (@PV-@FV)/@NPER ...