Foster Solutions (FSI)
The Solution is in the Process
If you build large Excel workbooks, you may have come across a weird error suddenly when you edited your file. You get an error that says “Too many different cell formats”. This will happen particularly with a large file that you have copy and pasted a lot of information from external sources. The following vba …
There is an easy way to remove duplicate rows from a SQL Server 2008 table, by using an undocumented feature called %%physloc%%. This pseudo column shows the physical location of a row. Please keep in mind that this is an undocumented feature and unsupported…. Use at your own risk! DELETE FROM dbo.mytable WHERE dbo.mytable.%%physloc%% …
When I first found out about functions in SQL Server, I thought it would be a silver bullet to modularize my code. In the end, I realized a strategy was necessary to prevent performance degradation. One helpful approach is to use temp tables.