If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1034

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1200

What kind of problems occurs if we do not implement proper locking strategy?

1479

Explain “row_number()” in sql server with an example?

1061

What are the properties of the transaction?

1059

Can you index views?

946

How to convert character strings into numeric values?

1167

What are the different SQL Server Versions you have worked on?

1071

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1015

What is sql or structured query language?

1206

Is it possible to have clustered index on separate drive from original table location?

1026

How do I create a trace in sql server?

1102

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2285

Where can you add custom error messages to sql server?

1190

do you know how to configure db2 side of the application? : Sql server database administration

1106