Overblog All blogs Top blogs Jobs, Education & Studies
Follow this blog Administration + Create my blog
MENU
Advertising
Advertising

What is SQL Profiler?

What is SQL Profiler? SQL Profiler is a tool that captures SQL Server events from the server and saves those events in what's known as a trace file. You can then analyze or use the trace file to troubleshoot logic or performance problems. You can use...

Read more

What is full outer join? *

What is full outer join? * The Full Outer Join logical operator returns each row satisfying the join predicate from the first (top) input joined with each row from the second (bottom) input. It also returns rows from: The first input that had no matches...

Read more

Advertising

Database Tuning Advisior in sql server

Database Tuning Advisior Database Engine Tuning Advisor analyzes a workload and the physical implementation of one or more databases. A workload is a set of Transact-SQL statements that execute against a database or databases that you want to tune. Database...

Read more

CUBE & ROLLUP in T-SQL

What are CUBE & ROLLUP in T-SQL? CUBE & ROLLUP are the grouping sets used in conjunction with GROUP BY clause to generate summarized aggregations. These are mainly used for Report Generation and Data Audits

Read more

Advertising

XML indexes in SQL Server

What are types of XML indexes in SQL Server? Microsoft SQL Server supports different types of XML indexes. An XML index is different than a relational index. There are basically TWO types of XML Indexes viz., Primary XML Indexes and Secondary XML indexes....

Read more

Sql server limitations of IDENTITY Column

What are limitations of IDENTITY Column? IDENTITY column can be used as a surrogate key. This column values cannot be updated once generated (automatically or manually). As we have possibility to duplicate these values within a table we may require to...

Read more

<< < 10 11 12 13 14 15 16 17 18 19 20 30 > >>