Viewing 15 posts - 46 through 60 (of 594 total)
eamonroche,
your proc looks ok. you may run into some performance problems further down the road if you're dealing with extremely high vlume datasets, but for now, everything...
September 3, 2003 at 7:59 am
Go ahead and post your real script, and we'll take a look.
September 3, 2003 at 6:52 am
Thanks for the reply. I'll try that out...
However, why would QA not effectively view the execution plan as the same as any other execution by the query optimizer? ...
September 2, 2003 at 2:55 pm
That's what stored procedures are for.
--
If you post the code, we can help convert it to a proc.
Edited by - jpipes on 09/02/2003 12:49:51 PM
September 2, 2003 at 12:49 pm
The message about "aggregate.." means that you are including a SUM(someColumn) along with other columns without specifying a GROUP BY clause.
--
However, this is a perfect case for another resultset. ...
September 2, 2003 at 12:35 pm
quote:
I'm a little confused about this. Isn't the clustered index actually on the data pages? If you specify a fill...
August 29, 2003 at 11:08 am
quote:
...just not sure what happens when it reaches the max size of size int...
Gee, that's...
August 29, 2003 at 7:21 am
quote:
ALTER DATABASE NorthwindSET SINGLE_USER
WITH ROLLBACK AFTER 30 SECONDS
Did they change this in SQL2K from SQL7? I ran it against my SQL7 server...
August 29, 2003 at 7:09 am
quote:
Will the datapages be read (while seeking the index) ?
Yes, since b's index is clustered....
August 29, 2003 at 12:49 am
quote:
Msgbox "Sorry, our programm does not fit for a user like you. Try somewhere else" ???
August 29, 2003 at 12:43 am
Try it with NOT EXISTS instead of NOT IN:
...
SELECT MIN(tt.TempID)
FROM @Temp tt
WHERE NOT EXISTS (SELECT * FROM tblBudgetYear)...
August 29, 2003 at 12:40 am
CREATE PROCEDURE GetFirstAvailableBudgetID
AS
SET NOCOUNT ON
--
DECLARE @Temp TABLE ([TempID] INT IDENTITY(1,1))
DECLARE @MaxCurrentBudget INT, @i INT
-- Grab the highest current budget
SELECT @MaxCurrentBudget = MAX(BudgetID) FROM tblBudgetYear
-- Populate Lookup
SET...
August 28, 2003 at 2:09 pm
tikus,
I was hoping that one of the more hardware-knowledgeable guys would have popped in to this thread by now, but alas, I guess not. I don't...
August 28, 2003 at 1:57 pm
quote:
Select A.a3, B.b3from A inner join B on A.a1 = B.b1 and A.a2 = B.b2
--
The performance is not impressive (both tables...
August 28, 2003 at 1:00 pm
The fillfactor setting for a clustered index on IDENTITY field can be set extremely high (95% - 99%), since there it is HIGHLY unlikely that a clustering key will be...
August 28, 2003 at 12:49 pm
Viewing 15 posts - 46 through 60 (of 594 total)