All Tips & Questions

1	Tip	Retrieve accurate row count for table
	Question	What is the difference between select count(*) and count(1) in sql server?

2	Tip	What it means DATEDIFF(DAY, 0, GETDATE())
	Question	How to apply NOLOCK when querying table using Linked Server?

3	Tip	Know your SQL Server Version by simple Select Query
	Question	SQL Server: What is the difference between EXEC and sp_executesql?

4	Tip	SQL Server: SQL aliases are used to temporarily rename a table or a column heading	Venkateswarlu Cherukuru
	Question	SQL Server: What is the difference between RANK() and DENSE_RANK() functions?

5	Tip	SQL Server : 3 Tricky SQL Queries Interview Questions and Answers	Venkateswarlu Cherukuru
	Question	SQL Server : How to concatenate multiple rows into a single text string ?

6	Tip	SQL Server : Disadvantages of dynamic SQL are...	Venkateswarlu Cherukuru
	Question	SQL Server : What are the difference between clustered and a non-clustered index?

7	Tip	Fully Qualify Your Database Object Names	Venkateswarlu Cherukuru
	Question	What is the difference between DELETE and TRUNCATE Statements in SQL?

FORUM

Search in the Site

Tip of the Day

Retrieve accurate row count for table
Read more...

Question of the Day

What is the difference between select count(*) and count(1) in sql server?
Click to see Answer

Connect With Us

About

Venkateswarlu Cherukuru, Post-Graduate from Sri Venkateswara University, Tirupati, India. Microsoft Certified Professional in Dot Net, SQL Server & HTML5 Technologies.