3 min read
0
Error : FILESTREAM feature is disable
Introduction Error – System.Data.Sqltypes.SqlClent.SqlError:FILESTREAM feature is disable. (Microsoft.SqlServer.Smo) Scenario A…
Author: OTI
Welcome to OurTechIdeas.com, your go-to destination for SQL Server DBA-related tech insights. We are a dedicated team of experts passionate about sharing our knowledge and expertise with the community. Join us as we explore the world of SQL Server, offering valuable tips, tutorials, and innovative solutions.
5 min read
0
Run a Job on few specific dates of every month in SQL Server
Introduction As per business requirements, a report needs to generate…
4 min read
0
Install SQL Server 2008R2 on Windows 2012R2
Introduction Installing lower version SQL Server on a higher version…
2 min read
0
Unable to begin a Distributed Transaction
Problem When your application uses the distribution transaction then you…
1 min read
0
Rename a Database in SQL Server
Introduction We can rename a user-defined database in SQL Server…
5 min read
0
Shrinking the Large Log File in SQL Server
Scenario We recently came across a situation where one of…
2 min read
0
Find the database file growth for all the databases in SQL Server
Introduction Find the database file growth for all the databases.…
2 min read
2
Database-Level Roles in SQL Server
Introduction There are two types of database-level roles: Fixed-database roles…
2 min read
1
How to get all statistics information for a database in SQL Server
Introduction: Sometimes your query gives you very bad performance because…
2 min read
0
Table backup in SQL Server
Introduction Here we will discuss different backup strategies and methodologies…