Tag Archives: database

SQL Server 2014 Health check DMV queries Day 2

This gallery contains 1 photo.

Hi guys in the Previous post i explained How we can get the SQL Server instance version and How we can know the installed date for SQL Server instance put today is DAY 2 and i will show new DMV in … Continue reading

Gallery | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Insert into table with default values only

In this article you will find how to insert a row without any specified values in SQL Server table, if the columns have default values. I recently had this issue. I had a table with only two columns one of … Continue reading

Posted in SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server Denali | Tagged , , , , , , | Leave a comment

Alter failed for Database – Unable to open the physical file

This gallery contains 1 photo.

Alter failed for Database ‘MFA’.  (Microsoft.SqlServer.Smo) —————————— ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) —————————— Unable to open the physical file “F:\databases\MFA.mdf”. Operating system error 5: “5(Access is denied.)”. Unable to open the physical … Continue reading

Gallery | Tagged , , , , | Leave a comment

Backup database – SQL Server Agent Job

The backup is not important…until you need it. It is very very important to backup your database. And you can schedule a job that will backup your database for you, and the creation is very simple. I have included for … Continue reading

Gallery | Tagged , , , , , , , , , | 2 Comments

DATABASE Configuration and Maintenance

This gallery contains 1 photo.

Files and Filegroups SQL Server to store in the database uses two different types of files: data and transaction log files. Instead of defining the storage of objects directly to a data file, SQL Server provide an abstraction layer for … Continue reading

Gallery | Tagged , , , , , , , , , | Leave a comment

Distributing and Partitioning Data in SQL Server 2008

This gallery contains 1 photo.

A Partition Function defines the set of boundary points for which data will be partitioned, otherwise a partition scheme provide an alternate definition for storage. You define a partition scheme to encompass one or more file groups. The final step … Continue reading

Gallery | Tagged , , , , , | Leave a comment

PREFERENCES FOR SQL SERVER 2008

This gallery contains 1 photo.

In the list below i have listed some of the preferences of SQL Server 2008, work that we come across we need to change, enabling or disabling these options or opportunities of SQL Server 2008.   SQL Server Service must … Continue reading

Gallery | Tagged , , , | 7 Comments