skip to main | skip to sidebar

SQL Server

Pages

Home

Thursday, January 7, 2010

Logical Query Processing

Posted by Dr. Parag Shukla at 7:14 PM

0 comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Total Pageviews

Blog Archive

► 2011 (1)
- ► January (1)

▼ 2010 (17)
- ► September (1)
- ► July (1)
- ► May (1)
- ► April (1)
- ► March (5)
- ► February (3)
- ▼ January (5)

► 2009 (21)
- ► December (5)
- ► November (9)
- ► October (1)
- ► August (1)
- ► July (2)
- ► June (3)

Popular Posts

SQL SERVER – Find Nth Highest Salary of Employee – Query to Retrieve the Nth Maximum value

This question is quite a popular question and it is interesting that I have been receiving this question every other day. I have already ans...
Charindex Vs Patindex

CharIndex PatIndex 1 Returns the Starting position of specified Expression in Character String. ...
SQL Challenge for Beginners - Find Factorial

The Challenge for Beginners This challenge is not a real time problem directly, but it measures about logical thinking. The problem is all ...
FOR XML PATH - How to generate a Delimited String using FOR XML PATH?

There are two common string operations where I used to write a TSQL loop in the SQL server 2000 era. To split a delimited string and return...
Rollup Vs Cube

Rollup Cube 1 The ROLLUP operator is useful for generating reports that contain subtotals and total...
List All Stored Procedure Modified in Last N Days

I usually run following script to check if any stored procedure was deployed on live server without proper authorization in last 10 days. If...
Msc(IT) DBMS Important Questions of SQL Server and Oracle

SQL SERVER QUESTIONS 1). Explain 12 rule defined by dr. E.F.Codd? 2). What is T-sql ? Explain T-sql Statements ? 3). Explain Database Ar...
Difference between DENSE_RANK() and ROW_NUMBER()

The difference between DENSE_RANK() and Row_number() is that Row_Number will generate a sequence of record one by one while DENSE_RANK() wil...
Get Branch and Complete Tree in SQL Server

This post is useful for developers who want to build a tree as per parent id, And a programmer who want a all child node from parent id. and...
SQL SERVER – 2005 – Find Nth Highest Record from Table – Using CTE

This question is quite a popular question and it is frequently asked question in interview that retrieve Nth highest record from table you ...

Followers

About Me

Dr. Parag Shukla: I am an academician, DBA and team leader at Department of Computer Applications. I am Oracle11g Certified Database Professional & Microsoft Certified Professional, earned Microsoft Database Administration and did Ph.D. in area of Big Data and Hadoop. I am IBM certified Academic associate – DB2 Database and applications & RAD Certified Developer. Nowadays working on Data Science and Mobile Application Development. This channel will helps to learners who are enthusiastic for coding. It also helps to the teachers as well as learners who want to learn Android, Java, Oracle, C, MongoDB, Flutter, SQL Server etc. "For the Learners, by the Learners & of the Learners. Thank You

View my complete profile

Label

Blog List

GTU MCA MATERIAL FOR DBMS II

Privacy Policy - Privacy Policy Effective date: March 08, 2019 PLSQL ("us", "we", or "our") operates the mobile application (the "Service"). This page informs you of our po...
5 years ago