-
Error : FILESTREAM feature is disable
17 October 2019Introduction Error – System.Data.Sqltypes.SqlClent.SqlError:FILESTREAM feature is disable. (Microsoft.SqlServer.Smo) Scenario A database backup from a test server provided to DBA team and asked to restore it on a pre-production SQL Server….
-
Run a Job on few specific dates of every month in SQL Server
16 October 2019Introduction As per business requirements, a report needs to generate four times every month. The report will generated by a Stored Procedure. So the DBA’s task is to execute the…
-
Install SQL Server 2008R2 on Windows 2012R2
15 October 2019Introduction Installing lower version SQL Server on a higher version of Windows Server may be problematic at times of installation. Recently we have faced such a scenario. We are sharing…
-
Unable to begin a Distributed Transaction
14 October 2019Problem When your application uses the distribution transaction then you may encounter below error. Error: The operation could not be performed because OLE DB provider “SQLNCLI11” for linked server “Linked_Server_Name”…
-
Rename a Database in SQL Server
11 October 2019Introduction We can rename a user-defined database in SQL Server by using SQL Server Management Studio or Transact-SQL. System databases cannot be renamed. The database name cannot be changed while…
-
Shrinking the Large Log File in SQL Server
10 October 2019Scenario We recently came across a situation where one of the drives in the production server is almost full. There are two large databases and they were not backed up….
-
Find the database file growth for all the databases in SQL Server
7 October 2019Introduction Find the database file growth for all the databases. It is not a good practice to keep your database file growth limited. In that case, you may get an…
-
Database-Level Roles in SQL Server
Introduction There are two types of database-level roles: Fixed-database roles db_accessadmin Granted: ALTER ANY USER, CREATE SCHEMA,Granted with Grant option – Connect By SSMS By TSQL USE [Our_Tech_Ideas] — Database…
-
How to get all statistics information for a database in SQL Server
4 October 2019Introduction: Sometimes your query gives you very bad performance because of statistics as SQL database engine Query optimizer uses statistics to create query plans. Updated statistics will give you good…
-
Table backup in SQL Server
Introduction Here we will discuss different backup strategies and methodologies used to take the table backup in SQL Server with real-life examples. There are different methods of taking backup in…