Viewing 15 posts - 61 through 75 (of 99 total)
Tara, what you want to say with "counts" ?
April 13, 2009 at 12:40 pm
Are you try update statistics for this table ?
April 13, 2009 at 8:35 am
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
April 13, 2009 at 7:42 am
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
April 13, 2009 at 7:15 am
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...
April 13, 2009 at 6:54 am
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...
April 13, 2009 at 6:42 am
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...
April 12, 2009 at 5:01 pm
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...
April 11, 2009 at 8:12 pm
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...
April 11, 2009 at 2:50 pm
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...
April 11, 2009 at 6:06 am
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. "
April 11, 2009 at 3:52 am
IF we see
Buffer Counts Buffers
------------------------------ --------------------
Committed ...
April 11, 2009 at 1:54 am
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...
April 10, 2009 at 5:47 am
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...
April 9, 2009 at 8:39 pm
Viewing 15 posts - 61 through 75 (of 99 total)