WebOver 7 years of professional IT experience in MS SQL Server Database Design, Development, Analysis and Reporting.Worked on various environments for installing, updating and configuring SQL server 2000/2005/2008/2008 R2/2012 on operating system Windows 2000/2008 server.Professional experience includes array of domains from … WebSQL Server 2000 also introduced many T-SQL language enhancements, such as table variables, user-defined functions, indexed views, ... SQL Server 2012's new features and enhancements include Always On SQL Server Failover Cluster Instances and Availability Groups which provides a set of options to improve database availability, ...
What
WebMay 2024 - Sep 20243 years 5 months. Pune, Maharashtra, India. Installation of SQL Server 2008, 2008R2, 2012, 2014, 2016, 2024 & 2024. • Backup and Restore. • Monitering Of server. • Ensured proper backup strategy was followed using Maintenance Plans. • Created and scheduled various jobs, stored procedures. • Configured DB Mail ... WebExperience in installation of different version of SQL Server on window platform by GUI, unattended, slip-stream. DB security, customized server roles in SQL server 2012 and solving login impersonation issue. Exposure of recovery models (Full, Bulk-logged, Simple & Pscheudo simple). Experience in database backup (Full, Incremental, T-log, Copy ... compost support program winnipeg
Venkat S Thota - Sr SQL DBA at IRIE Technologies LLC - Irie ...
Web2 jun. 2010 · An index is used to speed up the performance of queries. It does this by reducing the number of database data pages that have to be visited/scanned. In SQL Server, a clustered index determines the physical order of data in a table. There can be … Web16 sep. 2014 · I have recently converted our one large table to use table partitioning in SQL Server 2012. It's a table that stores logs based on a time. So I created a partition function to split the table on my [time] column which is of Type DATETIME2(2).My partion scheme … WebSQL Server 2000 also introduced many T-SQL language enhancements, such as table variables, user-defined functions, indexed views, ... SQL Server 2012's new features and enhancements include Always On SQL Server Failover Cluster Instances and … composts soil conditioners and mulches