Viewing 15 posts - 46 through 60 (of 108 total)
After railing against Hungarian notation in my earlier post, I must say that the one such convention I do find less offensive in sql is the prefixing of views with...
February 23, 2006 at 7:04 pm
how about:
update mytable set myflag = 1
from mytable a
where not exists (select * from mytable where barcode = a.barcode
...
February 20, 2006 at 4:29 pm
You undoubtably have a disk I/O bottleneck. The errors you posted, plus perfmon and/or profiler output should be good evidence to present to the sysadmins.
As for what to do about...
February 20, 2006 at 1:16 pm
I agree with Eddie and Jeff 10000 percent, and will go further (not minding stepping on toes) to say that I believe "Hungarian notation" to be a curse on the...
February 20, 2006 at 12:48 pm
It's hard to say without performing actual tests, but I suspect that the separate partitions won't help nearly as much as more physical disks. Assuming your disk controller(s) are up...
February 17, 2006 at 9:59 am
IMHO, developer awareness of referential integrity considerations, and attempts to enforce RI at the application or middle tier level is certainly commendable. However, the RDBMS provides a definitive (declaritive) level...
February 17, 2006 at 9:42 am
The transaction log is the main mechanism used to implement transactions, i.e. the Atomic, Consistent, Isolated, and Durable properties of the common A.C.I.D. definition. By providing a record of changes,...
February 15, 2006 at 9:29 am
Line 3 in your most recent post, wo.WONUM=es.WONUM looks extraneous to me. If that is what you were actually trying, try taking line 3 out.
Do you have a local Oracle...
February 14, 2006 at 11:38 am
I would definitely pursue the OPENQUERY route, in order to reduce:
1. confusion about what the middleware is actually doing.
2. likelyhood of above index problem interfering.
3. excess data clogging the network...
February 9, 2006 at 9:11 pm
This error is a common symptom of any one of a couple dozen causes. An excellent article in the Microsoft Knowledge Base will give you the entire run-down: Potential cases...
February 7, 2006 at 12:34 pm
Be aware that filegroup backups will only work when your recovery model is FULL.
Otherwise, filegroups are mainly used to control placement of objects by putting them on specific disks, either...
February 7, 2006 at 12:13 pm
It can be done directly with SQL Server, using the BACKUP and RESTORE commands. These work fine for all but the largest databases. Third-party backup utilities exist which can do...
February 6, 2006 at 1:36 pm
It depends on how dire the consequences of data loss and/or application unavailability are. If your users can go for a couple of weeks without the application, tape backups of...
February 6, 2006 at 1:08 pm
use stealth_mode
go
Maybe you could try putting in DRI into the database without telling anyone, making sure the proper indexes are there, etc.
Then see if your first complaint is about performance,...
January 29, 2006 at 6:58 pm
I would suspect a network outage of some sort.
January 28, 2006 at 8:15 am
Viewing 15 posts - 46 through 60 (of 108 total)