Not too sure I understand what you mean..could you expand? If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!
2003-07-08
2 reads
Thanks for your time SQLBill. So I have to do this in every query, for every table. That is going to be a nightmare for the developers. Can I write the code you suggested in the view definition? That way, the developers can jsut use the view name not worrying about the if? Thanks
2003-07-07
quote: I want to compare the DDL/Schema, Views and Stored procedures on two versions of my database. Is there any utility or scripts to do that ? Thanx in advance. Prateek.
2003-07-07
1 reads
Detaching and reattaching files sounds very disruptive to your production users. I would go with an option that has little or no disruption. Do you do your backup/copy/restore manually? If so, have you considered scheduling the activities to happen overnight. I'm assuming you do a backup anyway, so the additional processing time is the copy […]
2003-07-04
1 reads
Might have found the answer, would appreciate any feedback though. On the Repl-LogReader job agent step 2 run agent under advance retry attempts I change this to 10 to mirror production, this seems to have elevated the problem of the agent just failing out altogether. I should also mention that this problem does not occur […]
2003-07-02
2 reads
So, the QOD was a test to understand if we knew the workaround for a bug that has been fixed since MDAC 2.1? Hmmm.... -- Si Chan Database Administrator
2003-07-01
1 reads
2003-06-30
I suppose it depends on the maintenace scripts as well. If the index were to be used by a single script, the command could just be part of the script. Guarddata-
2003-06-27
Yes, you could do that as a job in SQL Server. I suppose the questions are how big are these tables and why go through the contortions to create the indexes nightly? Dr. Peter Venkman: Generally you don't see that kind of behavior in a major appliance. Patrick
2003-06-27
quote: I do not agree. The order of columns in your table should never matter. But that is the point. In this instance, the order of the columns DOES matter. Whether or not you use Select * or Select w/column names, you need to make sure any text columns are last in the ADO Fields […]
2003-06-27
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