SQL Server DBA questions

1. Difference between Cluster and Non Cluster Index
2. What is Page
3. Difference between Procedure, View, Function.
4. What's the difference between where and having.
5. What is fact and dimension
6. What's the difference between delete and truncate.
7. What is index tell me brief.
8. Types of temp table.
9. How you will get the data.
10. What was the most difficult scenario faced in ssis.
11. What kind of errors you can handled in ssis.
12. Break points.
13. Check points.
14. Event handler.
15. Performance tuning in SSIS
16. Deployment in ssis.
17. Blocking transformations.
18. SCD transformation brief explanation.
19. Term extraction.
20. Isolation properties.
21. Derived column expression.
22. Self join.
23. Types of joins explain briefly.
24. Character map transformation purpose.
25. Real time scenarios in sql-server.
26. Performance tuning in SQL Server.
27. Merge join.
28. Union all.
29. Multicast.
30. Error handling.

SQL Server Instance in Run Time

SELECT @@CONNECTIONS 'CONNECTIONS'

SELECT @@CPU_BUSY 'CPU_BUSY'

SELECT @@CURSOR_ROWS 'CURSOR_ROWS'

SELECT @@DATEFIRST 'DATEFIRST'

SELECT @@DBTS 'DBTS'

SELECT @@DEF_SORTORDER_ID 'DEF_SORTORDER_ID'

SELECT @@DEFAULT_LANGID 'DEFAULT_LANGID'

SELECT @@ERROR 'ERROR'

SELECT @@FETCH_STATUS 'FETCH_STATUS'

SELECT @@IDENTITY 'IDENTITY'

SELECT @@IDLE 'IDLE'

SELECT @@IO_BUSY 'IO_BUSY'

SELECT @@LANGID 'LANGID'

SELECT @@LANGUAGE 'LANGUAGE'

SELECT @@LOCK_TIMEOUT 'LOCK_TIMEOUT'

SELECT @@MAX_CONNECTIONS 'MAX_CONNECTIONS'

SELECT @@MAX_PRECISION 'MAX_PRECISION'

SELECT @@MICROSOFTVERSION 'MICROSOFTVERSION'

SELECT @@NESTLEVEL 'NESTLEVEL'

SELECT @@OPTIONS 'OPTIONS'

SELECT @@PACK_RECEIVED 'PACK_RECEIVED'

SELECT @@PACK_SENT 'PACK_SENT'

SELECT @@PACKET_ERRORS 'PACKET_ERRORS'

SELECT @@PROCID 'PROCID'

SELECT @@REMSERVER 'REMSERVER'

SELECT @@ROWCOUNT 'ROWCOUNT'

SELECT @@SERVERNAME 'SERVERNAME'

SELECT @@SERVICENAME 'SERVICENAME'

SELECT @@SPID 'SPID'

SELECT @@TEXTSIZE 'TEXTSIZE'

SELECT @@TIMETICKS 'TIMETICKS'

SELECT @@TOTAL_ERRORS 'TOTAL_ERRORS'

SELECT @@TOTAL_READ 'TOTAL_READ'

SELECT @@TOTAL_WRITE 'TOTAL_WRITE'

SELECT @@TRANCOUNT 'TRANCOUNT'

SELECT @@VERSION 'VERSION'

Microsoft Excel Shortcut Keys

Ctrl + A Selects the entire worksheet. If the worksheet contains data, and selects the current region

Ctrl + B Applies or removes bold formatting

Ctrl + C Copies the selected cells

Ctrl + D Copies the value from the cell above the active cell into the cell or the Formula Bar.

Ctrl + E Flash Fill - Automatically fills in values

Ctrl + F Displays the Find and Replace dialog box, with the Find tab selected.

Ctrl + G Displays the Go to dialog box

Ctrl + H Displays the Find and Replace dialog box, with the Replace tab selected.

Ctrl + I Applies or removes italic formatting

Ctrl + K Inserts a hyperlink

Ctrl + L Displays the Create Table dialog box

Ctrl + N Creates a new, blank workbook

Ctrl + O Displays the Open dialog box to open a file

Ctrl + P Displays the Print dialog box

Ctrl + S Save a workbook/sheet

Ctrl + T Displays the Create Table dialog box

Ctrl + U Applies or removes underlining

Ctrl + V Paste

Ctrl + W Closes the selected workbook window

Ctrl + X Cuts the selected cells

Ctrl + Y Redoes the last command or action

Ctrl + Z Uses the Undo command to reverse the last command or to delete the last entry that you typed.