Tara, what you want to say with "counts" ?

Are you try update statistics for this table ?

Using row_number we can enumerate the business day (1,2,3,4)..see it was "over by date"... somenthing like "number of the line"

Correct me if i´m wrong Jack

Good idea Jack, unless change the schedule, verify daily if is the 1 and 3 business day.

Your formula to see this with CTES go to my favorite scripts...heheheh

Lets say you have a table with this structure

Create table Test (code int, name varchar(50))

1 - Without nothing (Clustered IndexI,PK, identity)

you can create a new identity column and send to...

You can move this table withou creating clustered indexes, you can create a new table in the new filegroup, insert de data with insert/select , drop the old table and...

As far i Know, in SQL2K5 when you change the noise word file this apply in entire sql server and all databases fulltext indexed runing on it, by instance.

I...

I dont know how is work with almost 1 TB, and i dont know if have a better solution, but if you create a clustered index in this tables using...

The first businnes day of the month is very relative. Exmple...i´m from brazil and we can a day off (holiday sample) and in your contry no.

So I THINK its...

I dont understand dynamic column...

are want to say computed column ?

or dynamic column in pivots ?

If was a computed column just add de computed column and the value and will...

Well,

Slava Oks say ..

"on 64 bit platform, locked pages, awe mechanism, enable better application's scalability and performance both during ramp up time and over long period of time. "

IF we see

Buffer Counts Buffers

------------------------------ --------------------

Committed ...

Keep in mind when you use udf functions in "where" clause, it is change the where sargable to NONsargable and sql server wiil not use indexes if they exists. (this...

I had the same problem in a migration and most problems were resolved rebuilding all my indexes and recompiling all stored procedures.

but some queries (few) stay with performance...

Thanks Steve !!!