Siusic Dot Com

I frequently need to update large amount of data, like tens of millions of rows.

Usually the update request comes as that there is a table (let’s call it new_table) with a record id column (record_id) and a few other columns, say date_field1, data_field2 and data_field3 that need to be updated into another table (old_table). […]

Today someone showed me a SallieMae statement and told me that she pay a fixed amount, 300 dollars, every month for her student loan and ask me why the amount applied to the principal of the loan is different every month. In order to show her I really have an MBA degree I spend a […]

If you are working with SQL Server then you will find from time to time you will need to import data from Excel into SQL server in order to query or manipulate the data easily. One way and I think the most used method to import data from Excel into SQL server is to use […]

I have several SQL server jobs that copy files around the network folders and all of them were failed one day. The error message showed in the job history was, “Unable to determine if the owner of job has server access (could not obtain information about windows NT group/user”. The job step that failed was […]

I encountered a problem at work when I was requested to set up one way transactional replication between two databases. The subscribing database already have the tables of the replication and there were many tables in the subscribing database that have foreign keys referencing the replicating tables. So guess what? The initial push of the […]