T-SQL How to know what locks are held on the database. How to extract query text of a SPID. How to identify each connection inside SQL Server. How to restore Full, differential backup of database. How to avoid transaction log fill up's. How to know log space utilized by each database. What are the possible Data transfer methods and why are they used for in general? How to create a batch file using SQL files from a folder? How to create a table partition and what do I need to create a partition on the table.? what does partitioning means, its advantages and disadvantages.? what is database compatibility mode and how to set it.? index scan vs index seek? How to detect fragmented Indexes and rebuild or re organize to de fragment indexes.? What is Index Fragmentation and how to detect it.? When to Create an Index and When not to create and Index on a table or view? What is an Index. How to create and Index and How many types of Indexes are there? How Statistics affect query execution plans and what will be their effect. What are statistics properties details and what those terms means to me.? When to create statistics and when to update statistics.? What are statistics.How do they get created, what are the options that can be set on a database level? How to run a script from Command Prompt. xmp_cmd shell usage inside TSQL How to flatten rows in a column into a single row.? How to notify an alert using an email operator. How to create an alert based on a custom error message. How to know when, where, what and who about a database backup set on a backup file. How to retrieve database backup, log backup file information. How to create Full, LOG backup of database. How to get Current Time Zone Information of SQL Server How to create a Recursive CTE How to revert back a change or data entered in a statement. Calculate Sum, Average, Moving Average and Cumulative Totals without using GROUP BY. Recompile a stored procedure How to change a value to different datatype. How to use INTERSECT and EXCEPT Set Operators How to store large sets of data temporarily into an object when to use union and when to use union all, and which is better in performance How to repeatedly execute a statement on a conditional logic. How to shrink a log file, data file or Truncate a data file. How to combine results from two or more queries. How to exit from the query using RETURN How to set a delay for a query to run. How to control the flow of the execution using GOTO How to override default behavior of SQL Server Optimizer. How to use CROSS APPLY in sql server How to use CASE statement in a where clause. How to know what Indexes are on a table and columns. How to Implement validation sets using triggers on a table. How to track data changes on a table or view when an insert happens or delete happens. How to query SQL data into XML How to transform multiple columns to rows in SQL Server How to Transform rows into column in SQL Server. How to use SQL_VARIANT, TimeStamp, UniqueIdentifier and XML datatypes How to purge(delete) records using SQL Server Agent. How to update or delete using JOINS How to create custom formatting, conversion or validation using scalar functions How to create and use a table valued function. How to check foreign key constraints columns on a table using a query. How to use JOINS in SQL Server
0 comments:
Post a Comment