Microsoft SQL Server Databases
I’ve seen the implicit conversion issue in SSMS while looking over query execution plans and I found this blog about the topic: Are VARCHAR or CHAR Hurting Your Performance Due To Implicit Conversions? The developer’s […]
I ran across a question on StackOverflow, I did not understand the full scope of the question; however, I added my answer. We run into situations when migrating data when there is a table that […]
In .Net we are familiar with Try/Catch blocks and you can do this in SQL Server running SQL transactions as well with the additional benefit of “undoing” what was started if something were to fail […]
I received the above error message from a client and at first glance, the paths are correct. The correct path is: O:\NetTrax\02 – ProductionReports – Production But, look at the 2nd hyphen (Reports – Production), […]
Every so often I need to test something with remote device processing, today happens to be one of those times. I could print some barcodes, scan them, and then process the device. Here is another […]
I needed to replicate a character 24 times in one instance and in another I had to prefix a value with leading zeros (total of 24 characters). SQL Server has a REPLICATE function that makes […]
After copying a database the ASP.Net Membership permissions might not be set for the user you are trying to connect to resulting in the error: The EXECUTE permission was denied on the object ‘aspnet_CheckSchemaVersion’, database […]
Learned a lot about SQL Server Integration Services (SSIS) and ETL packages in the last few days… I have 36,934 XML files in several subdirectories that needed to be imported into a SQL database so […]
I have a string value in a column in my table. It’s a full path and filename for a .tif image. I needed to get just the filename as a column. I couldn’t use a […]
