Just reread your last post, and the answer to your question quote: in one table there are duplicate case no.s and in other it is as unique. Now how can u join the two different tables and have distinct output.? is: basically, you can't, unless you use 'group by' and aggregate functions (see BOL, Transact_SQL […]
2003-06-23
Unfortunately, this is started automatically. I have found KB 328885 and some others. I have patched the server with a fix for the above KB (received from MS and looks to be part of SP4) no help. I have found some articles RE: this and multi. NICS however have 5 other servers same config and […]
2003-06-19
1 reads
Services.exe is the services manager for the OS. The only KB article I've found (perhaps others will have better luck) is if it is started interactively. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-06-19
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-19
quote: I may know quite a bit but I still haven't figured out the best way to present myself. And I am looking to partner with some local guys and start up my own company more than anything. And the thing that has held me back is my bennifits package (it was the best, but […]
2003-06-18
Hi Elian, quote: I just drop these couple of lines to remind you there 3 licences of myLittleAdmin (full version) to win in the QOD this week ! woh, I was ahead of time. I received the annoucement as part of my planetsourcecode membership (on Sunday?) There is a price for QOD?. One win, one […]
2003-06-17
6 reads
I have some comments 1- the triger will not affesct the performane (as I know) ... and you can use Stored procedure in stead of it (in case you call stroed procedure in deleting a Row ) 2- there is another solution, "Linked Servers", so u can make a table in another server and see […]
2003-06-17
The problem you have there is lack of a root node. Not to serious though. To get exactly what you want, have a look at EXPLICIT. You can do it with that. There is an example in BOL which does that useing Pubs DB. That is what I used and hacked it apart. Another solution […]
2003-06-17
One thing I have done is to delete a case using the test server and use profiler to find all the tables involved in the delete. There was a total of 19. This means I have to write triggers for all the 19 tables to store the deletes. What will be the effect on performance.?
2003-06-17
2 reads
Hello. How about using trigger(s) to write the deletes to archive table(s). Everett
2003-06-16
1 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers