Frank, I've read your article and I am a bit confused. I accept the performance overhead of dynamic SQL (not caching query plans) and the security aspects (giving specific permissions on tables rather than just exec permissions on procedures). However, I'm not sure whether in this case you are making us aware of the pitfalls […]
2003-05-16
1 reads
The "outer join" solution shouldn't have been necessary. All sales-detail product id's should have been in the products master table making the outer join unnecessary. Seems to me there are referential integrity problems and orphaned sales-detail rows somewhere.
2003-05-15
1 reads
2003-05-12
2 reads
How about scripting the stored procedures from the old database (Enterprise Manager -> Objects -> Generate SQL Scripts -> etc.), and then pull the script into Query Analyzer and select and run chunks of them (like 20 questions) until you narrow down the bad procedure?
2003-05-12
1 reads
check Denormalisation on the web. There a whole set of info needed to take that decision
2003-05-08
1 reads
For production system, I agree, just say no. Manage space usage based on the business needs (slow time) and don't rely on Auto Shrink. I've found some "production" systems such as Crystal Reports that use MSDE with auto close enabled. so review every install, and do an inventory of all your production system if you […]
2003-05-06
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