At LA_Fitness, we deploy SQL stored procedures, functions, triggers, scripts ... and web application every weekday on the average of 25 deploys daily. Developers test on development and test environment...
copy the script onto Notepad. Remove all those tiny rectangular shapes (which were interpreted as spaces which cause errors), then copy the whole script back onto SSMS, parse again. You...
I ran into the same situation. I was assigned to identify and remedy poor performing queries on an extremely heavy use production server. First I was using SQL...
Is there anyway - WITHOUT HAVING TO RESTART THE SERVER - to move the transaction log file and/or master files of 'tempdb' to another separate physical drive to boost performance?...