Data Engineering – Learn from the experts
-
Disk space Check via SQL Server
Im writing this script since most of them are looking a way to find total diskspace available in a drives through sql server. I hope there is no extended procedure for this. Ive used WMI script to do this, Copy the vbs script and save it to a location as diskspace.vbs and use this location…
-
Difference between TRUNCATE and DELETE command
Lets see the difference between DELETE and TRUNCATE command as below
-
How to use Copy Database Wizard
What is copy database wizard? Copy Database Wizard is a new feature from SQL Server 2005 onwards. You can make use of this feature to copy move databases between different instances of SQL Server. It can be used for the below purposes Transfer a database when the database is still available to users by using…
-
How to find TCPIP port via T-SQL
In most of the forums I’ve seen that users are not able to find on which port does their sql server is listening. Hence I decided to write a script to check TCPIP port on which sql server is listening. Checkout the below script.
-
Frequently Used Catalog Views – SQL 2005
Catalog views return information that is used by the Microsoft SQL Server 2005 Database Engine. You can make use of these catalog views because they are the most general interface to the catalog metadata and provide the most efficient way to obtain, transform, and present customized forms of this information. Catalog views do not contain…
Got any recommendations?