Thank you.

Found this supporting blurb in BOL

Rebuilding or reorganizing small indexes often does not reduce fragmentation. The pages of small indexes are stored on mixed extents. Mixed extents are shared...

Fragment_Count = 4

Avg_Fragment_Size_In_Pages = 1

Page_count = 4

Date table, of course!

PM'd.

Nice script.

I opted to include it as part of my nightly production backup maintenance plan so that the test database is always "fresh."

What is the amount in condition #1?

b_boy (8/19/2008)

---

with this query, i want to pull out records of NEW customers who have:

1-placed an order over a certain amount

2-requested for an order over a certain amount to be...

What constitutes a "new" customer?

Rosh's suggestions will work. Or, if T_ICPAudit.Amount is a monetary amount, why not cast it as MONEY?

Yes! ...

I don't know Buzz. If you do a datepart/week on your starting day it returns week 19.

Which makes sense becuase the @Date variable is our week 18 plus week...

4/27 is a Sunday. I just used DATEPART/week to determine the week of that date.

Select datepart(week,'2008-04-27')

The TSQL Class (Course 2071, Querying MS SQL Server 2000 with T-SQL (2 days)) would be a waste of your time.

The database programming class is really what you're looking...

How much does this person already know? What kind of TSQL duties will be asked of them?

I took the New Horizon's after class after a few months of teaching...

You should be able to see the file sizes increase. Try running this command (shows you physical file sizes) before and after you load the data:

select size from sys.database_files

In the SQL 2005 Server Management Studio, right-click>properties your database, choose the 'files' page, and check the 'path' column. This should be were your database physical files reside.