Tammy-274861 (7/12/2014)

---

Hi Lynn!

That is a good question. I was assuming that if the enrollment date is for instance 2/1/2013, that's when the enrollment starts and if termination date is on...

Congrats!!

Here are some comments regarding the code. Of course, the best way to learn what is happening is to break things down and display the parts in the query.

datediff(day,case...

First change, I had the number of days in the active year hard coded. Wouldn't work for a leap year:

/*

Member ids that should be returned from the initial sample...

Tammy-274861 (7/12/2014)

---

awww....so far away. Sorry and take care there!

I am looking at your solution, sorry to bother again, but can you explain what you are doing here:

...

Then dropping and recreating the clustered indexes on the new filegroup should do just what you are looking for here. A quick check of BOL seems to concur with...

Question I have is this, are you just trying to move only indexes, meaning nonclustered indexes or are you actually move the tables to a new file group?

Thank you.

I did make a slight change to itvf function in my post above.

Thought you'd like to see some code that will help:

declare @BirthDate date;

set @BirthDate = '1959-07-29';

select datediff(year,@BirthDate,getdate()) - case when dateadd(year,datediff(year,@BirthDate,getdate()),@BirthDate) > getdate()

...

enrique.mallon (7/12/2014)

---

Hi tommy

Such condition arises when SQL Server database becomes deadlock and you are unable to perform action or transaction on it. It means that your SQL database got...

You are going to have to wait out the rollback. There is nothing you can do to speed it up.

One thing I learned at a previous employer, because I took the time to hone and advance my skills on my own time, I was able to get my employer...

I stay away from the INFORMATION_SCHEMA views as well. As mentioned, they are incomplete when it comes quite a bit of information. Also, they are not as portable...

Sean Lange (7/11/2014)

---

I am about to head of here for the week. Then Sunday starts 3 days at Webelos camp with my oldest. I will be outside fending off the...

I am assuming that you are not talking about a persisted calculated column. That calculation, iirc, is done once and then stored. It isn't updated unless the column...