Hi With the info provided, I would consider replication, simple enough and effective. Do you need to go back the other way or it will be 1-way replication only? Another option is simply a bunch of "smart" triggers that do the same sort of thing, perhaps into a staging table and reapplies the DML back […]
2003-06-25
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
Unfortunately i have not got the luxury of using external tools as I'm trying to use whatever is available within SQL Server itself. Would querying sysperfinfo every few minutes solve your dilemma (re: gathering perf stats)? I seem to remember seeing a script on this site which used this method:-)
2003-06-17
Well then there isn't much to say then. It is not difficult. I would create them in a new publication, because when you change the stored procedure, iw will not replicate the changes. So you will have to drop and re create the publication. Or you can also execute sp_addscriptexec (Check in BOL) by adding […]
2003-06-11
Right Click DYNAMIC database --> New --> Database Diagram --> follow the wizard to generate the diagram.
2003-06-09
1 reads
Try: DELETE FROM Orders FROM Orders INNER JOIN ( SELECT Order_No, Line_No, MAX(Ship_Date) as MaxShipDate FROM Orders GROUP BY Order_No, Line_No ) AS dt ON Orders.Order_No = dt.Order_No AND Orders.Line_No = dt.Line_No AND Orders.Ship_Date <> dt.MaxShipDate
2003-06-04
What's the difference between MIN and First and MAX and Last. YOu can also use TOP clause and the order by clause to produce the results needed. Edited by - jpipes on 05/29/2003 08:48:18 AM
2003-05-29
1 reads
But he's asking about First and Last, which don't have corresponding functions in T-SQL. I've wished for these at times myself. Jay Madren
2003-05-29
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