sql server experienced interview questions Different Companies

Comments

Post a Comment

Popular posts from this blog

Filegroups - Creating a new file group and making it the default

Image
Ref-1 https://blog.sqlauthority.com/2009/05/31/sql-server-create-multiple-filegroup-for-single-database/ https://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/07/11/881.aspx https://www.sqlshack.com/database-table-partitioning-sql-server/ https://blog.sqlauthority.com/2013/08/15/sql-server-sql-basics-what-are-filegroups-day-9-of-10/ Filegroups - Creating a new file group and making it the default There are many occaisons where you may want to use multiple filegroups, especially if dealing with large tables and fragmentation is a worry. The script below shows a complete end-to-end example of how to create a file group and mark it as the default so all newly created objects are placed on there. Note, there is nothing you can do about [PRIMARY] so if you have creation scripts or drop / recreate index scripts with [PRIMARY] in them then that data will always go on the [PRIMARY] file group. -- Create the database CREATE DATABASE te...
Read more

Using SQL Server DMVs to Identify Missing Indexes

Image
https://www.mssqltips.com/sqlservertip/1634/using-sql-server-dmvs-to-identify-missing-indexes/ Problem In a previous tip, Deeper insight into unused indexes for SQL Server , we discussed how to identify indexes that have been created but are not being used or used rarely.  Now that I know which indexes I can drop, what is the process to identify which indexes I need to create.  I can run the Database Tuning Advisor or examine the query plans, but is there any easier way to determine which indexes may be needed? Solution As with a lot of the new features we have seen with SQL Server 2005 and now with SQL Server 2008, Microsoft introduced a few more dynamic management views to also assist with identifying possible index candidates based on query history. The dynamic management views are: sys.dm_db_missing_index_details - Returns detailed information about a missing index sys.dm_db_missing_index_group_stats   - Returns summary information about missing inde...
Read more