Difference between rowid and rownum in SQL?
Answer Posted / yash
the difference between ROWNUM and ROWID is that ROWNUM is temporary while ROWID is permanent
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
How many types of triggers are there?
What do we need queues in sql service broker?
What are page splits?
What is meant by Active-Passive and Active-Active clustering setup?
Explain about Normalization?
Why do we use functions?
Difference between group by clause and having clause in SQL?
What is the purpose of forms?
What are the steps to follow to configure SQL*Net?
Difference between report and query parameter. Why do we need different type of parameter?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
Explain what are the basic functions for master, msdb, model, tempdb databases?
What is sql server english query?