<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
100 Most famous interview Questions and...
39 posts, Page 1 of 4
1
2
3
4
»
»»
100 Most famous interview Questions and Answers
Rate Topic
Display Mode
Topic Options
Author
Message
rajeshpalo
rajeshpalo
Posted Monday, October 29, 2012 4:52 AM
Grasshopper
Group: General Forum Members
Last Login: Wednesday, January 23, 2013 9:05 PM
Points: 16,
Visits: 143
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
Mark Eckeard
Mark Eckeard
Posted Monday, October 29, 2012 2:29 PM
SSC Journeyman
Group: General Forum Members
Last Login: Saturday, March 30, 2013 12:00 PM
Points: 82,
Visits: 348
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
Luis Cazares
Luis Cazares
Posted Monday, October 29, 2012 2:39 PM
SSC Eights!
Group: General Forum Members
Last Login: 2 days ago @ 3:26 PM
Points: 958,
Visits: 1,917
It worked using just lower case.
The document does not have a great format. It's hard to read.
Luis C.
Please don't trust me, test the solutions I give you before using them.
Forum Etiquette: How to post data/code on a forum to get the best help
Post #1378469
Jeff Moden
Jeff Moden
Posted Monday, October 29, 2012 5:17 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Yesterday @ 8:21 PM
Points: 32,893,
Visits: 26,765
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 "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1378521
mickyT
mickyT
Posted Monday, October 29, 2012 6:04 PM
SSC Veteran
Group: General Forum Members
Last Login: Thursday, May 16, 2013 1:32 PM
Points: 294,
Visits: 1,101
{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
Lynn Pettis
Lynn Pettis
Posted Monday, October 29, 2012 7:35 PM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 12:22 AM
Points: 21,588,
Visits: 27,384
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
Jeff Moden
Jeff Moden
Posted Monday, October 29, 2012 9:22 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Yesterday @ 8:21 PM
Points: 32,893,
Visits: 26,765
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 "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1378550
Luis Cazares
Luis Cazares
Posted Monday, October 29, 2012 9:41 PM
SSC Eights!
Group: General Forum Members
Last Login: 2 days ago @ 3:26 PM
Points: 958,
Visits: 1,917
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.
Please don't trust me, test the solutions I give you before using them.
Forum Etiquette: How to post data/code on a forum to get the best help
Post #1378553
Jeff Moden
Jeff Moden
Posted Monday, October 29, 2012 9:57 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Yesterday @ 8:21 PM
Points: 32,893,
Visits: 26,765
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 "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1378555
Jeff Moden
Jeff Moden
Posted Monday, October 29, 2012 9:59 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Yesterday @ 8:21 PM
Points: 32,893,
Visits: 26,765
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 "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1378556
« Prev Topic
|
Next Topic »
39 posts, Page 1 of 4
1
2
3
4
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
