December 15, 2016 at 9:57 am
You can try the attached SqlCleaner. It was written a few years ago and definitely depends on the command starting with exec sp_executesql N'SELECT yada yada
and ending with something like this:
N'@DerivedTable01_CLIENT_ID30 int,@DerivedTable01_CLIENT_ID61 int,@DerivedTable01_CONCRETE_TYPE113 varchar(8000),@DerivedTable01_BUSINESS_PROCESS_STATUS134 varchar(8000),@DerivedTable01_BUSINESS_PROCESS_STATUS145 varchar(8000),@DerivedTable01_STATUS166 varchar(8000),@DerivedTable01_CONCRETE_TYPE187 varchar(8000),@DerivedTable01_BUSINESS_PROCESS_STATUS208 varchar(8000),@DerivedTable01_STATUS229 varchar(8000),@DerivedTable01_CONCRETE_TYPE2410 varchar(8000),@DerivedTable01_BUSINESS_PROCESS_STATUS2611 varchar(8000),@DerivedTable01_CONCRETE_TYPE2812 varchar(8000),@DerivedTable01_BUSINESS_PROCESS_STATUS3013 varchar(8000),@DerivedTable01_STATUS3214 varchar(8000),@DerivedTable01_SERVICE_REQUEST_STATUS3415 varchar(8000),@DerivedTable01_BUSINESS_PROCESS_STATUS3616 varchar(8000),@DerivedTable01_STATUS3817 varchar(8000),@DerivedTable01_CONCRETE_TYPE4018 varchar(8000),@DerivedTable01_BUSINESS_PROCESS_STATUS4219 varchar(8000),@DerivedTable01_CUSTOM_ATTRIBUTE_44420 varchar(8000),@DerivedTable01_BUSINESS_PROCESS_STATUS421 varchar(8000),@DerivedTable01_NAME622 varchar(8),@DerivedTable01_923 varchar(32),@DerivedTable01_BUSINESS_PROCESS_STATUS524 varchar(8000),@DerivedTable01_NAME725 varchar(8),@DerivedTable01_1126 varchar(32)',@DerivedTable01_CLIENT_ID30=11330,@DerivedTable01_CLIENT_ID61=11330,@DerivedTable01_CONCRETE_TYPE113='Fdi.Po.FollowUpRequest',@DerivedTable01_BUSINESS_PROCESS_STATUS134='Open',@DerivedTable01_BUSINESS_PROCESS_STATUS145='Closed',@DerivedTable01_STATUS166='NO_TITLE_PM',@DerivedTable01_CONCRETE_TYPE187='Fdi.Po.TitleMaintenanceRequest',@DerivedTable01_BUSINESS_PROCESS_STATUS208='Open',@DerivedTable01_STATUS229='TITLE_MAINTENANCE_REQUEST_SENT',@DerivedTable01_CONCRETE_TYPE2410='Fdi.Po.DuplicateTitleRequest',@DerivedTable01_BUSINESS_PROCESS_STATUS2611='Closed',@DerivedTable01_CONCRETE_TYPE2812='Fdi.Po.DirectLendingServiceRequest',@DerivedTable01_BUSINESS_PROCESS_STATUS3013='Open',@DerivedTable01_STATUS3214='NO_TITLE_PM',@DerivedTable01_SERVICE_REQUEST_STATUS3415='DocumentsReturned',@DerivedTable01_BUSINESS_PROCESS_STATUS3616='Closed',@DerivedTable01_STATUS3817='NO_TITLE_PM',@DerivedTable01_CONCRETE_TYPE4018='Fdi.Po.AdHocRequest',@DerivedTable01_BUSINESS_PROCESS_STATUS4219='Open',@DerivedTable01_CUSTOM_ATTRIBUTE_44420='01102',@DerivedTable01_BUSINESS_PROCESS_STATUS421='Open',@DerivedTable01_NAME622='REMINDER',@DerivedTable01_923='Fdi.Workflow.Po.ReminderWorkItem',@DerivedTable01_BUSINESS_PROCESS_STATUS524='Open',@DerivedTable01_NAME725='REMINDER',@DerivedTable01_1126='Fdi.Workflow.Po.ReminderWorkItem'
December 19, 2016 at 10:46 am
This was basically my introduction to SQL. Doing Tech Support for an app build on Java using Hibernate. It was a small team with a couple of developers and no DBAs on the team. Our software was use was mixed with some of it being in hosted in house on MS-SQL servers with others being hosted by our customers with most of those using Oracle. Definitely saw some of the things discussed in here but luckily for us Hibernate hadn't started falling down completely or gotten two bad performance wise because our data was still pretty small. Typically our large databases only got up into the teens of gbs with only a couple tables getting big. We even did several of the things on the list of things not to do like using the built in caching and thread pools. I'm sure a good team with the right people who really knew what they are doing could completely rebuild the app and make it so much better but that is just a dream and not my problem anymore 😀
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply