SQL Server Interview Questions And Answers

Question

SQL Server Interview Questions And Answers

Viewing 4 posts - 31 through 33 (of 33 total)

You must be logged in to reply to this topic. Login to reply

Randheer SSC Eights! Points: 985 More actions · Answer 1

My Blog SQLServerQuest.com is getting updated with new interview questions which will help you to understand the various aspect of SQL Server.

Revisit those SQL Server interview questions for better understanding.

Randheer Singh

----------------------------------
CheckOut My Blog for SQL Server Realated Topics and Interview Questions for SSIS , SSRS and TSQL.

http://www.sqlserverquest.com/p/ssrs-interview-questions.html
http://www.sqlserverquest.com/p/ssis-interview-questions.html
http://www.sqlserverquest.com/p/tsql-interview-questions.html

Jeff Moden SSC Guru Points: 1003865 More actions · Answer 2

All of the links I clicked on in your T-SQL site leader to "blogger.com/about".

Did you ever fix the delete vs truncate answers? They were really wrong at the beginning of this post.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Randheer SSC Eights! Points: 985 More actions · Answer 3

Thanks Jeff for highlighting the issues. I also couldn't understand how it happened as every thing was working fine. I will correct it.

Also my answers are also in update mode. let me fix and reupdate on this forum. Open for any of the suggestion.

Randheer Singh

----------------------------------
CheckOut My Blog for SQL Server Realated Topics and Interview Questions for SSIS , SSRS and TSQL.

http://www.sqlserverquest.com/p/ssrs-interview-questions.html
http://www.sqlserverquest.com/p/ssis-interview-questions.html
http://www.sqlserverquest.com/p/tsql-interview-questions.html

Brandie Tarvin SSC Guru Points: 172995 More actions · Answer 4

Your workplace asks some interesting questions, but anyone reading this thread should be aware that it's specific to your workplace and other employers (like my team) doesn't ask questions like these. This reads more like a "you passed an exam now prove it" than it does "you have workplace experience solving problems and working as a team, tell us about it" kind of site.

There are also just too many "define this" questions where the answers do anything but define the objective in the question to make me comfortable recommending your blog to anyone. And if anyone came to one of my interviews armed with this information, they would not get a second interview.

I understand you're trying to make it easier for people interviewing for DBA jobs, but people who know SQL Server shouldn't have to memorize BOL to be able to get their foot in the door of a workplace that values experience and team work over memorization.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.