3 min read
0
Change ‘TempDB’ file location in SQL Server
Introduction The TempDB database is essential to SQL Server’s management…
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.
3 min read
1
Determine or Estimated time (ETA) of Backup & Restoration
As a DBA you may face a few common questions…
4 min read
2
4 min read
0
8 min read
0
Find Server Information by TSQL script
Display all Server Information by using TSQL script The below…
2 min read
0
3 min read
1
2 min read
0
Find cached execution plan
An execution plan, simply put, is the result of the query optimizer’s attempt…
8 min read
3
Configuring Database Mail in SQL Server
SQL Server Database Mail facilitates email communication directly from the…
2 min read
0
SQL Network Interfaces, error: 26
SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified…