MSBI lo pani chese vallu randi va plz.. ..help plz..

[Renault]

i have some q;ns ...in interiew..plz answer

[Android_Halwa]

@loveindia

[khabardar]

post ur qustins 1st

[SwamyRaRa]

52 minutes ago, khabardar said:

post ur qustins 1st

Gp 

[Renault]

Please answer below q'ns

 

When inserting a record into a table having an identity column, how do you capture the newly-generated number

1.     How would you capture the last identity value created by your database session (assuming other connections are actively inserting records into the same table)?

How would you run a dynamically-generated T-SQL string?

When running a dynamically-generated T-SQL string, which method has a chance of reusing query plans?

What tools do you use when determining query performance?

1.     When using SQL Profiler, what do you measure when comparing the performance of 2 queries that are constructed differently but return the same set of data?

What might you see in a query plan that would indicate a potential performance issue?

Are there instances where a table scan does not indicate a performance issue?  That is, are table scans ok sometime?

What is a potential drawback of adding an index to a table? What is a potential drawback of adding an index to a table?

1.     How do you check for errors in T-SQL scripts?

[Android_Halwa]

LTT

[mtkr]

When inserting a record into a table having an identity column, how do you capture the newly-generated number

Scope IDentity

1.     How would you capture the last identity value created by your database session (assuming other connections are actively inserting records into the same table)?

@@Identity

How would you run a dynamically-generated T-SQL string?

Exec and sp_executesql

When running a dynamically-generated T-SQL string, which method has a chance of reusing query plans?

sp_executesql

What tools do you use when determining query performance?

SQL traces and Database engine tuning advisor

What might you see in a query plan that would indicate a potential performance issue?

Depends... cost, indexes, seek or scan....

Are there instances where a table scan does not indicate a performance issue?  That is, are table scans ok sometime?

Good on small data tables...

What is a potential drawback of adding an index to a table?

Adds disk space... slows onserts and updates,,...

How do you check for errors in T-SQL scripts?

using Try Catch block

[mtkr]

29 minutes ago, Renault said:

Please answer below q'ns

 

When inserting a record into a table having an identity column, how do you capture the newly-generated number

1.     How would you capture the last identity value created by your database session (assuming other connections are actively inserting records into the same table)?

 

How would you run a dynamically-generated T-SQL string?

When running a dynamically-generated T-SQL string, which method has a chance of reusing query plans?

What tools do you use when determining query performance?

1.     When using SQL Profiler, what do you measure when comparing the performance of 2 queries that are constructed differently but return the same set of data?

 

What might you see in a query plan that would indicate a potential performance issue?

Are there instances where a table scan does not indicate a performance issue?  That is, are table scans ok sometime?

What is a potential drawback of adding an index to a table? What is a potential drawback of adding an index to a table?

1.     How do you check for errors in T-SQL scripts?

 

ee anni Qs ki google lo ans untaiiii

[Android_Halwa]

7 minutes ago, mtkr said:

ee anni Qs ki google lo ans untaiiii

babu ki google lo question search chesina, answer ela chudalo telidu anukunta

[sarvamangalam]

atb ltt

[Renault]

1 hour ago, mtkr said:

When inserting a record into a table having an identity column, how do you capture the newly-generated number

Scope IDentity

1.     How would you capture the last identity value created by your database session (assuming other connections are actively inserting records into the same table)?

@@Identity

How would you run a dynamically-generated T-SQL string?

Exec and sp_executesql

When running a dynamically-generated T-SQL string, which method has a chance of reusing query plans?

sp_executesql

What tools do you use when determining query performance?

SQL traces and Database engine tuning advisor

What might you see in a query plan that would indicate a potential performance issue?

Depends... cost, indexes, seek or scan....

Are there instances where a table scan does not indicate a performance issue?  That is, are table scans ok sometime?

Good on small data tables...

What is a potential drawback of adding an index to a table?

Adds disk space... slows onserts and updates,,...

How do you check for errors in T-SQL scripts?

using Try Catch block

thanks baaa

 

[Renault]

1 hour ago, mtkr said:

ee anni Qs ki google lo ans untaiiii

ee q'n ki kuda ans cheppu ba..google la dorkatle

When using SQL Profiler, what do you measure when comparing the performance of 2 queries that are constructed differently but return the same set of data?

[mtkr]

15 hours ago, Renault said:

ee q'n ki kuda ans cheppu ba..google la dorkatle

When using SQL Profiler, what do you measure when comparing the performance of 2 queries that are constructed differently but return the same set of data?

profiler use cheyyaled bro eppudu...

http://stackoverflow.com/questions/7569186/compare-two-sql-server-profiler-traces

 @Renault