Can you create a Primary key without clustered index? IDENTITY column can be used with a tables column to make it auto incremental, or a surrogate key.Ĭheck my all blog posts related to IDENTITY: ġ8. What is an IDENTITY column and its usage in INSERT statements? What should be the ideal combination with IN & UNION (ALL) in terms of performance?ġ7. Difference between Temporary Table and Table Variable.ġ6. Difference between COALESCE() & ISNULL()ġ5. Multiple ways to execute a dynamic query.ġ4. This will help in deploying the pkg created in DEV server to Testing and finally to the PROD environment.ġ3. How will you migrate an SSIS package from Development to Production environment?ĭo not include db connections and file paths in your workflow, instead create configuration files. OUTER LEFT/RIGHT JOIN with WHERE clause can act like an INNER JOIN if not used wisely or logically.ġ2. Difference between LEFT JOIN with WHERE clause & LEFT JOIN with no WHERE clause.
Why you should not use a cursor? What are its alternatives?Īlternatives: while loops with temp tables, derived tables, correlated sub-queries, CASE stmtġ1. What are Cursors and their types? What type do you use most and which one is fast?įORWARD-ONLY, FAST-FORWARD or READ-ONLY cursors.įastest to slowest: Dynamic, Static, and Keyset.ġ0.
How will you insert result set of the above proc in a table?ĩ. How can you execute a DOS command from SQL or through SQL query by using xp_cmdshell?Ĩ. What are extended stored procedures? Can you create your own extended stored-proc?ħ. More differences on Delete & Truncate: | YouTube.Ħ. – DELETE is DML just like INSERT, UPDATE, but TRANCATE is DDL, just like CREATE, ALTER, DROP If not then none of them can be rollbacked. – Both statements can be rolled backed if provided in a transaction (BEGIN TRANS). – TRUNCATE is faster than DELETE as Delete keeps log of each row it deletes in transaction logs, but truncate keeps log of only de-allocated pages in transaction logs. – With DELETE we can provide conditional WHERE clause to remove/delete specific rows, which is not possible with TRUNCATE. Difference between DELETE & TRUNCATE statement? Which statement can be Rollbacked? How can you execute an SQL query from command prompt?ĥ. What is SQL Profiler? What it does? What template do you use?Ĥ. Query Analyzer, Profiler, Index Wizard, Performance Monitorģ. What tools do you use for performance tuning? – Ranking functions (ROW_NUMBER, RANK, DENSE_RANK, NTILE), Ģ. Difference between SQL Server 2000 & SQL Server 2005 features, or new features of 2005 vs 2000. … I’ll be updating this post with more questions.ġ. These are the following common question that I faced in various TSQL interviews.
0 kommentar(er)
