Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

100 Most famous interview Questions and Answers Expand / Collapse
Author
Message
Posted Monday, October 29, 2012 4:52 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 13, 2014 6:01 AM
Points: 17, Visits: 148
Please go to the following link:-
http://sqlcheatsheet.wordpress.com/2012/10/26/sql-server-2008-2008-r2-cheatsheet/

Download the PDF (sqlserver2008r2_cheatsheet_v1-01.pdf). Password: harinam

This is very good document for the freshup your memories with SQL Server features.


Cheer's
Rajesh
Post #1378190
Posted Monday, October 29, 2012 2:29 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 5:24 AM
Points: 128, Visits: 490
Says the password is incorrect. I tried copy and paste from your post as well as typing it in using both lower and upper case.

Makr



Post #1378464
Posted Monday, October 29, 2012 2:39 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 8:20 PM
Points: 3,943, Visits: 8,951
It worked using just lower case.
The document does not have a great format. It's hard to read.



Luis C.
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1378469
Posted Monday, October 29, 2012 5:17 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 8:55 PM
Points: 35,618, Visits: 32,214
rajeshpalo2003 78748 (10/29/2012)
Please go to the following link:-
http://sqlcheatsheet.wordpress.com/2012/10/26/sql-server-2008-2008-r2-cheatsheet/

Download the PDF (sqlserver2008r2_cheatsheet_v1-01.pdf). Password: Harinam

This is very good document for the freshup your memories with SQL Server features.


For all those who would use such a thing... Caveat Emptor!

And while you're studying such canned answers, be advised that a lot of us don't ask canned questions on interviews especially for senior positions. For example...


{Me} How many columns can a table have?
{You} 1,024!
{Me} So why are INSERTs designed to handle up to 4,096 columns?
{You} {wtf???}


--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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1378521
Posted Monday, October 29, 2012 6:04 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, November 26, 2014 4:24 PM
Points: 1,081, Visits: 3,171

{Me} How many columns can a table have?
{You} 1,024!
{Me} So why are INSERTs designed to handle up to 4,096 columns?
{You} {wtf???}

Something else to go and investigate Could be a QOTD
Post #1378527
Posted Monday, October 29, 2012 7:35 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:09 AM
Points: 20,815, Visits: 32,749
Jeff Moden (10/29/2012)
rajeshpalo2003 78748 (10/29/2012)
Please go to the following link:-
http://sqlcheatsheet.wordpress.com/2012/10/26/sql-server-2008-2008-r2-cheatsheet/

Download the PDF (sqlserver2008r2_cheatsheet_v1-01.pdf). Password: Harinam

This is very good document for the freshup your memories with SQL Server features.


For all those who would use such a thing... Caveat Emptor!

And while you're studying such canned answers, be advised that a lot of us don't ask canned questions on interviews especially for senior positions. For example...


{Me} How many columns can a table have?
{You} 1,024!
{Me} So why are INSERTs designed to handle up to 4,096 columns?
{You} {wtf???}


Or:
{me} Why would you have table with that many columns?
{Interviewee} ?????



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1378536
Posted Monday, October 29, 2012 9:22 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 8:55 PM
Points: 35,618, Visits: 32,214
mickyT (10/29/2012)

{Me} How many columns can a table have?
{You} 1,024!
{Me} So why are INSERTs designed to handle up to 4,096 columns?
{You} {wtf???}

Something else to go and investigate Could be a QOTD


The answer will be a huge surprise to those not used to this type of questioning... especially if I've already told them that the environmet they'll be working in is 2005


--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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1378550
Posted Monday, October 29, 2012 9:41 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 8:20 PM
Points: 3,943, Visits: 8,951
Lynn Pettis (10/29/2012)
Jeff Moden (10/29/2012)
rajeshpalo2003 78748 (10/29/2012)
Please go to the following link:-
http://sqlcheatsheet.wordpress.com/2012/10/26/sql-server-2008-2008-r2-cheatsheet/

Download the PDF (sqlserver2008r2_cheatsheet_v1-01.pdf). Password: Harinam

This is very good document for the freshup your memories with SQL Server features.


For all those who would use such a thing... Caveat Emptor!

And while you're studying such canned answers, be advised that a lot of us don't ask canned questions on interviews especially for senior positions. For example...


{Me} How many columns can a table have?
{You} 1,024!
{Me} So why are INSERTs designed to handle up to 4,096 columns?
{You} {wtf???}


Or:
{me} Why would you have table with that many columns?
{Interviewee} ?????


I know. To support a bad database design.

The idea might be good for a cheat sheet (poorly executed) but it shouldn't be taken as a guide for a good interview.



Luis C.
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1378553
Posted Monday, October 29, 2012 9:57 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 8:55 PM
Points: 35,618, Visits: 32,214
mickyT (10/29/2012)

{Me} How many columns can a table have?
{You} 1,024!
{Me} So why are INSERTs designed to handle up to 4,096 columns?
{You} {wtf???}

Something else to go and investigate Could be a QOTD


Actually, it could be two questions. One for SQL Server 2005 and one for 2008.

But this is what I'm talking about. Even if all the answers in such cheat sheets were correct (and I assure you, they are not) and someone were able to recite every single answer without hesitation, they still wouldn't pass a real interview because such cheat sheets don't teach a person how to think and they certainly don't give you "experience" for a senior position.


--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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1378555
Posted Monday, October 29, 2012 9:59 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 8:55 PM
Points: 35,618, Visits: 32,214
Luis Cazares (10/29/2012)
Lynn Pettis (10/29/2012)
Jeff Moden (10/29/2012)
rajeshpalo2003 78748 (10/29/2012)
Please go to the following link:-
http://sqlcheatsheet.wordpress.com/2012/10/26/sql-server-2008-2008-r2-cheatsheet/

Download the PDF (sqlserver2008r2_cheatsheet_v1-01.pdf). Password: Harinam

This is very good document for the freshup your memories with SQL Server features.


For all those who would use such a thing... Caveat Emptor!

And while you're studying such canned answers, be advised that a lot of us don't ask canned questions on interviews especially for senior positions. For example...


{Me} How many columns can a table have?
{You} 1,024!
{Me} So why are INSERTs designed to handle up to 4,096 columns?
{You} {wtf???}


Or:
{me} Why would you have table with that many columns?
{Interviewee} ?????


I know. To support a bad database design.

The idea might be good for a cheat sheet (poorly executed) but it shouldn't be taken as a guide for a good interview.

Preeeeeeecisely.


--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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1378556
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse