ExpertConnect - Mentoring & Discussions

You can join mentoring & discussions for Free Ask Question, Give Answer, Discuss IT Problems, Learn, and Grow

2017-10-20 14:11:17 11

SQL Server 2014

SQL Server 2014 is relational database management system (RDBMS) designed for the enterprise environment. Released on April 1, 2014, SQL Server 2014 runs on the Structured Query Language (SQL), but has several notable differences from its immediate predecessor SQL Server 2012

Topic menu

2017-11-09 12:59:50 0
What's in your mind?
Profile picture of Virat  Bakshi
Virat Bakshi
Public
Posted: Nov 9, 2017

Why is it better to use an in-line table valued function than a multi-statement table valued function?

Comment (1) ·  Like (1)
Profile picture of Jeff Rathjen

Jeff Rathjen Nov 9, 2017

Inline TVFs return the result of a query without consuming all of the memory. Multi-Statement TVFs populate a variable and then return that variable. This uses far more memory and is much slower.

Like

Write a new comment...
Ready to post? select an option:
Profile picture of Virat  Bakshi
Virat Bakshi
Public
Posted: Nov 9, 2017

When I create a Trigger, where do I see it in the Object Explorer?

Comment (1) ·  Like (1)
Profile picture of Jeff Rathjen

Jeff Rathjen Nov 9, 2017

It depends on how you created the trigger. If you created it on the Database, it will show under Programmability\Triggers. If you created the trigger on a table, it will appear under TableName\Triggers.

Like

Write a new comment...
Ready to post? select an option:
Profile picture of Mindy  Clark
Mindy Clark
Public
Posted: Nov 9, 2017

Does the RANK() function work in PL/SQL?

Comment (1) ·  Like (2)
Profile picture of Jeff Rathjen

Jeff Rathjen Nov 9, 2017

While I have never done it, there is documented support for RANK() in PL/SQL

Like (1)

Write a new comment...
Ready to post? select an option: