LEARN SQL

SQL DBA 2018 Latest interview questions?. If Database size is 500GB then what is TempDB Size in that Server? Why Restore job is taking long time compare to before log restore in logShipping? What are the Tempdb enchancements in 2016 sql server? If TUF is corrupt in logShipping what Happend? What are the 2016 new features? what is StrechDB? Model database is Correpted on that time Instance running fine. After restrting the istance is not responding why?How you will resolve? What is CXPAKET? What is AlwaysOn? What is the basic requiremets to configure AlwaysOn? Can you configure One listner to multiple AG Groups? if yes How? If no why? Can you explain How AlwaysOn Ag work flow? What are the DMV's using in Daily? Can you list out few regular XP's your using? what are the DBCC commands your using?

How do I find a long running query with process ID, process name , login time, user , start time and duration? Long running queries have been found in the plan cache. These may be ETL, reports, or other queries that should run long. Or it could be that someone is searching for all users whose names are LIKE '%%'. Either way, these queries bear investigating. In some cases, this is the total clock time that the query took to execute and in others this is the total CPU time that the query took to execute. Queries with a high max_elapsed_time just take a lot of time to run – they could be slow single threaded queries. Queries with a high max_worker_time (CPU time) may be highly parallel queries. CODE: SELECT  creation_time         ,last_execution_time         ,total_physical_reads         ,total_logical_reads         ,total_logi...

What is SQL Stands for Structured Query Language it lets you Access and manipulate databases What Can SQL do Create new databases  Syntax: CREATE DATABASE database_name create new tables in a database  Syntax: CREATE TABLE table_name (column1 datatype, column2 datatype, column3 datatype,); Insert records in a database  Syntax: INSERT INTO table_name VALUES (value1, value2, value3, ...); Retrieve data from a database  Syntax: SELECT * FROM table_name; NOTE: insted of * you can use fileds which fileds we want retrive. Delete records from a database  Syntax: DELETE FROM table_name WHERE condition; Update records in a database  Syntax: UPDATE table_name SET column1 = value1, column2 = value2, WHERE condition; Execute queries against a database Create stored procedures in a database Create views in a database Set permissions on tables, procedures, and views However, to be compliant with the ANSI standard, they all support...