Hi guys, One of my friend shared interview questions asked at Microsoft-
- when sql server is not responding or not started what action will you take place?
- What is the diff b\w 32 bit &64 bit sql server?
- what is max memory in sql server?
- How you resolve deadlocks? How will u to enable trace flag 1222,1204 ? if u found error in error log regarding deadlock occurred then how u resolve?
- Diff b\w login & user?
- when i am configure backup job..my job is failed .how you resolve ? what are the steps u follow?
- Types of recovery models?
- why we didn't take transaction log backup in simple recovery model?
- Suppose in my workstation i have 16 GB RAM...i have set max memory 8 GB then sql server uses remaining memory or not..if yes how?
- What is the use of trace flag number -T3608?
No comments:
Post a Comment