Viewing 15 posts - 331 through 345 (of 461 total)
quote:
sql = "Select id,activityType,regarding,link,projectName,date,fromEmail,toEmail,subject,body,isRead,adminAlert,custAlert from jobActivity where id = "& request("quoteId") &" order by date desc "
October 7, 2003 at 9:54 am
Some questions to check:
- What about the statistics?
- Are they up to date (check with DBCC SHOW_STATISTICS ( table , target ))?
- Do you have the same amount of data?
-...
October 6, 2003 at 7:19 am
I still do not understand well your select but I have some issues with that:
- Why do you have this interresting where clause: "WHERE 0=0"
- you should remove (AR.Transaction_Type IN...
October 6, 2003 at 6:57 am
Just a stupid question:
- Are all your indexes participating in the primary-forign key pairs all right and well defined?
- Do you have triggers defined on the participating tables
If your...
October 6, 2003 at 6:46 am
SQLBill is right.
If any of your disk (of cours I mean here disk array - RAID1, RAID5...) hosting the data, index, Log, system, tempdb fails you won't be able to...
October 3, 2003 at 11:26 am
What does it mean Select @seq from ( select SeqNbr deom DELETED ).
It is incorrect.
You have to type:
select @seq = SeqNbr from DELETED
But do not forget that you...
October 3, 2003 at 11:19 am
Why not to use a temporary table or table variable, insert your data then select then at once?
Bye
Gabor
October 3, 2003 at 11:11 am
I suppose you are prepared to handle the licencing issue. i.e. you have a processor licence instead of server/CAL based licence otherwise you wont be able (or allowed to access...
October 3, 2003 at 11:06 am
Inserting one million records in one batch represents 2 kind of problems:
- Log space
- Tempdb space if the source you are selecting from involves the tempdb (temp table, sort, group...
October 3, 2003 at 8:48 am
Yes but the book of Kalen is not really for novices!
But of course it gives you a complete picture what is going on behind the scene.
Bye
Gabor
October 3, 2003 at 4:49 am
We have an SAP over here.
A lot of modules, over 1000 users, the DB size of the productive DB is 250 GB after 1,5 years and the size grow is...
October 3, 2003 at 4:36 am
As long as you have an order by clause you cursor will be read only!
I've xperienced that problem as well.
The only way is to implement a clustered index to get...
October 3, 2003 at 4:16 am
The "read only" flag as you want to implement is application specific. i.e. in you enduser app (VB, Delphi, C#...) you have to define you recordset or data grid as...
October 3, 2003 at 4:12 am
Steve,
In your case, as I've already told you, you should implement a kind of search form where the user is entereing the search criteria and based on those criteria you...
October 3, 2003 at 4:05 am
I personnaly don't like that kind of programing behavior in a client/server environment.
That one fits well on a standalone database/application of Clipper/ACCESS... type of database.
I usually let enter the key...
October 2, 2003 at 8:20 am
Viewing 15 posts - 331 through 345 (of 461 total)