Viewing 15 posts - 2,806 through 2,820 (of 3,616 total)
Anything that involves a string function will have a performance hit.
For example, let us suppose that you want to retrieve all names beginning "Smi".
Using WHERE PersonName LIKE 'Smi%' will be...
February 28, 2005 at 2:03 am
What about the IBM/Sony/Toshiba Cell processor? Cell 9 is supposed to behave like 9 CPUs on one chip and therefore you are talking about 9 computers with blindingly fast...
February 24, 2005 at 3:26 am
I found what I considered to be a bug in ADOX and therefore stopped using it.
The exact details as far as I remember were as follows.
As far as ADOX...
February 24, 2005 at 3:17 am
I don't have SQL to hand to test this but
Use the DATEDIFF function to find the number of days, then your average will be SUM(STATE) / DATEDIFF(d, @startDate, @EndDate)
February 24, 2005 at 2:26 am
It is worth looking at the help text for XCOPY because there are a number of switches that are extremely useful.
I have to copy across a backup file from one...
February 23, 2005 at 1:53 am
I notice that you are using DAO.
I last touched MS Access 6 years ago and at the time Microsoft were pushing ADOX as the way to manipulate MS Access objects...
February 23, 2005 at 1:46 am
In the UK we are bombarded with adverts for shredders at £xx.xx and everyone is looking at them and thinking "hmmm... that is pretty good value".
Call me a...
February 23, 2005 at 1:42 am
I think that this subject is worth an article if anyone is prepared to write it.
Scenarios, Pros, Cons, Gotchas etc.
February 23, 2005 at 1:39 am
According to books on line it is 1,048,516 TB.
It does say that the maximum size of any one file in the database can be 32TB and that the maximum number...
February 22, 2005 at 1:49 am
I am pretty sure that shrinking the database requires an exclusive lock on the database so if anyone access the database the shrink will fail.
February 22, 2005 at 1:38 am
Looking at index 3.
If you search for records with just an ACCT_DT field in the WHERE clause the index will be used.
If you search for records based on ACCT_DT and...
February 18, 2005 at 10:22 am
Sysindexes holds more than just indexes. If you see entries such as _wa_sys_etc then these are system generated statistics.
Similarly, if you have generated manual statistics then these will also...
February 18, 2005 at 7:21 am
I have two database servers where the logins have been transferred so they both have the same sid values.
This means that I can simply do an automated BACKUP and RESTORE...
February 17, 2005 at 1:59 am
Do you have a clustered index on the table and if so on what column(s)?
How many indices are there on your table? Do you really need them?
It is always...
February 17, 2005 at 1:55 am
Viewing 15 posts - 2,806 through 2,820 (of 3,616 total)