Answer / Srish Kumar

{"The main differences between Access and SQL Server are as follows:
1. Database size - SQL Server can handle larger databases compared to Access
2. Concurrent users - SQL Server supports a higher number of concurrent users than Access
3. Programming - SQL Server requires structured query language (SQL), while Access can be programmed using Visual Basic for Applications (VBA)
4. Operating system compatibility - SQL Server is compatible with various operating systems like Windows, Linux, and macOS, whereas Access runs only on Windows}

What is the purpose of floor function?

1 Answers  

---

Explain Geography datatype in SQL Server

1 Answers   Infosys,

---

Explain external key management in sql server 2008

1 Answers  

---

How can I get data from a database on another server?

1 Answers  

---

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

---

how do u do Performance tunning ?

1 Answers   Infodat Technologies, Satyam,

---

How can you fetch alternate records from a table?

1 Answers  

---

what is the difference between delete,drop and truncate

2 Answers   Honeywell, Zomato,

---

Explain the truncate command? : SQL Server Architecture

1 Answers  

---

If we shrink the Databse and Files, how much size is decreased?

1 Answers   TCS,

---

What is the difference between a clustered index and a non-clustered index?

1 Answers  

---

Can we perform backup restore operation on tempdb?

1 Answers  

---