Siusic Dot Com

A query to display all user tables in a database and sort them by decending order according to row counts is very useful when it comes to research and

discover where data are stored in a complex database. I found such query very helpful from time to time. I have collected a few of them […]

After writing previous post about using window

batch command to rename all files in a folder I found using VB Script to do the same thing is much easier.
Let’s say you have a few thousand files named in the same pattern like transaction_xxxxx.txt in a folder called test. You want to rename all these […]

I was trying to write a batch file to rename

all files in a folder on windows. And the following is what I came up with. It worked very well. I found one of the great usage of my blog was to archive whatever script I came up with. It could help someone to quickly […]

I found a lot of posts on the internet regarding how to set up a MSSQL link server to MySQL server. I didn’t find any of them gave a complete picture. So I wrote my own post and hope it can help.
The first thing need to do when setting up a link server to […]

I was told by various documentations and technical articles that SQL Server Query Optimizer does a good job on selecting which index to use when establishing a query execution plan. And it is in rare cases that you will find justification to use index hint. I believe I encountered this kind of rare cases a […]