Personally, I hate that particular cliche. There's also no "we" in "success". There is an "i" in "win". ...

Good question. My answer for soft skills is Scientology. Very effective.

The other thing to check, with the script in the job, is whether or not the job is running it in the right database. I can't count the number...

The reasons you give for using a cursor are pretty much the exact reason to NOT use one.

In the specific problem given, I am willing to bet you a week's...

Mazharuddin Ehsan (7/17/2008)

---

Here is the solution using the Dense_rank(). The row_number() suggested by GSquared

will be ineffective in case of ties.

DROP TABLE #Employees

CREATE TABLE #Employees (Emp_No INT, EName VARCHAR(5), Sal INT)

INSERT...

It looks to me like you've already hit on the right solution. Someone else may have a better suggestion, but I'd go for it with that.

Here's how I'd solve this:

Create a Numbers table.

Use that to create a Calendar table, with all dates in the range you're querying against.

Do a From-To self-join for each log table,...

Jeff Moden (7/17/2008)

---

ALI (7/17/2008)

---

Thanks for your comments.

I did solve above issue and got stuck with other. As I have tight production deadlines, I am going for cursor in a stored...

I recommend the nested Order By solution, here's why:

;with CTE (Row, Number) as

(select row_number() over (order by col2), col2

from dbo.sometable)

select *

from cte

where row = 2

/*

=================

Without Index

=================

SQL Server parse and compile...

Is the "EffectiveDate" in PriceInstances the same as the "DateEntered" in the other three tables?

If so, and you have a DateEntered of 17 July 08 for ItemA, and a DateEntered...

Yes, an update trigger will fire even if the update sets the data to the same thing as it was before.

You can handle that with a join between "inserted" and...

Is there anything else running on the server, or just Windows Server and SQL Server?

Books Online has step-by-step directions on how to turn on full text indexing. I recommend following those directions.

It can affect performance, but Books Online also has data on how...

Are you sure the service is stopping and not just databases set on auto-disconnect, or something like that?

And, if the service is stopping, do you have it set to auto-restart...

The advantage to separate filegroups is they can be on separate disks, if it's under a RAID configuration that allows that. If, for example, the whole database is on...