25
votes
7answers
3k views

What is the difference between a “record” and a “row” in SQL Server?

There was a rather innocuous question about adding dates and times in SQL Server that set off a rather fascinating taxonomic debate. So how do we differentiate between these related terms and how we ...
2
votes
1answer
2k views

What are SQL Server Securables?

I migrated two applications to the new server. One of the them works without any issues but the other ran into back end sql permission problems like The EXECUTE permission was denied on the ...
4
votes
1answer
850 views

What is Sql Server Clustered Index in Oracle terminology

A clustered index in sql server like a dictionary or telephone directory. A,B,C,D it goes on. If you look up with a name Ozgur you start O then z etc. I would like a simple explaination for this ...
8
votes
2answers
5k views

What is a heterogeneous query?

I got the following error message regarding a SQL query I'm running in a program. SQL Server 2005 T-SQL. Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the ...