How To Use ALTER TABLE in SQL Server

Sometime you want to modify exists table in database. You don't want to delete and recreate. So in SQL Server we can use Alter Table to modify table. We can delete columns, add new columns, modify columns name, modify datatype.

Please follow below scripts:

1. Add Column

Syntax: Alter Table TableName ADD NewField DataType

EX: Alter Table tbl_Staff Add DOB DateTime

How to know Last Backup Date in SQL Server

My friend asked me about one problem in SQL Server. He cannot find the last backup date in SQL Server. He asked me help him find scripts to query last backup date. I try a few days for find this scripts. Finally I found one scripts that can query this data.

How to Remove Pagefile.sys on Hard Disk

I have a problem with my laptop, in drive C has grew up without reason. I tried to find all folders but didn’t see big file or folder. I have wondered why my hard drive is growing up like this. Then I found the cause of this issued. This problem is happened by has pagefile.sys in drive C. What is pagefile.sys? Pagefile.sys is the “Virtual Memory” or “Swap Space” that it come from RAM when not currently begin used. I never delete this file, now its size is 8GB. To solves this issued we can reduce its size or don’t allow to have this file in hard disk.

How to Find Empty Table in SQL Server

Today I have a good tip to share about find empty table in SQL Server. Sometime you created table in database, but you didn’t insert any rows. Once day you want to optimize or want to delete some table, you should run this query to know which empty table. It is necessary to clarifies the empty table for prevent lost your data before you delete it.

5 Ways to Improve Computer performance

This topic will guide you to improve your computer speed. After you read this tips you are able to fix when your computer going to slow. Because when we use computer everyday it will be grow of unnecessary file and have a lot case to make your computer slowly. You didn't know there are a lot of service is running when we use computer for other work. Some services also run while computer no need. So we need to know how to stop those services. But first we must know why and what the