Viewing 15 posts - 10,681 through 10,695 (of 26,489 total)
Not knowing anything more about the table, it looks like this query as written in the original post would benefit from a filtered covering index in SQL Server 2008.
July 17, 2012 at 4:56 pm
Guessing from a previous post that this is SQL Server 2000, correct?
July 17, 2012 at 4:54 pm
David Webb-200187 (7/17/2012)
July 17, 2012 at 4:50 pm
Evil Kraig F (7/17/2012)
GilaMonster (7/17/2012)
capn.hector (7/17/2012)
Lynn Pettis (7/17/2012)
Really???does not seem to be the same welsh as when i first started posting.
or is it
I don't know. There have been some seriously...
July 17, 2012 at 4:46 pm
Read this: http://www.sqlservercentral.com/articles/T-SQL/67898/
Since you are using SQL Server 2008, stay away from using @@rowcount to control your batches.
July 17, 2012 at 4:38 pm
pooyan_pdm (7/17/2012)
No of course shrinking the data files ends in fragmented indexes.
Cool, someone that actually knows that! You'd be amazed at those who don't.
July 17, 2012 at 3:16 pm
gerard-593414 (7/17/2012)
If two users run the code:
If exists(selectAcnum...
July 17, 2012 at 3:02 pm
Here is one way. study it and be sure to ask questions where you don't understand what is happening.
Select distinct
a.artid,
a.catid,
a.Title,
...
July 17, 2012 at 2:42 pm
Using a CTE, I think this is a little cleaner.
WITH BaseData AS (
SELECT
id,
nm,
SUM(AMT*1000) AS value
FROM
...
July 17, 2012 at 2:24 pm
Sounds like two different language settings on the servers (OS).
July 17, 2012 at 2:13 pm
Koen Verbeeck (7/17/2012)
Lynn Pettis (7/17/2012)
rodjkidd (7/17/2012)
Lynn you beat me to it! They will just have to hire someone new to fill the B.A. position.
Grant, I did think about you and...
July 17, 2012 at 11:21 am
If I remember correctly there is a part of Indiana that also does not recognize DST. So, depending on Daylight Savings Time or Standard Time, they are eith in...
July 17, 2012 at 11:12 am
Viewing 15 posts - 10,681 through 10,695 (of 26,489 total)