Category Archives: Microsoft SQL Server

This is an interesting post I came across by Saleem Hakani. I have not tested it yet. It promises to reduce the time for Creating a database Expand data files for additional growth Automatic data file growth due to auto-grow … Continue reading

Link | Posted on by | Tagged | Leave a comment

Some Useful SQL queries

I have compiled below some SQL queries that I have been using regularly. I can’t take credit for writing all of them, though. /*get size and free space in a database*/ SELECT DB_NAME() AS DbName, name AS FileName, size/128.0 AS … Continue reading

Posted in Microsoft SQL Server | Tagged , | Leave a comment

Export all jobs from a SQL server

To export all jobs from a SQL server. Open ssms,connect to your sql server.Navigate to SQL Server Agent– jobs. Click View and select Object Explorer Details or press F7. The Object explorer details window should open on the right. Select … Continue reading

Posted in Microsoft SQL Server | Leave a comment