Creating Views - SQL School Video

Question

Post reply

Creating Views - SQL School Video

Brian Knight

One Orange Chip

Points: 27249
More actions
July 30, 2008 at 9:21 pm

#63648

Comments posted to this topic are about the item Creating Views - SQL School Video
Brian Knight
Free SQL Server Training Webinars

Viewing 12 posts - 1 through 11 (of 11 total)

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

Anipaul SSC-Insane Points: 24681 More actions · Answer 1

Good one. Are we going to get more videos like this?

Brian Knight One Orange Chip Points: 27249 More actions · Answer 2

You'll see a few of these a week. I've already sent SSC a dozen and another 30 will be sent to them by week end. We also have loads more for free on JumpstartTV.com

Brian Knight
Free SQL Server Training Webinars

SuperDBA-207096 SSCrazy Eights Points: 8176 More actions · Answer 3

Brian,

Awesome work! What tool did you use to create the video?

Brian Knight One Orange Chip Points: 27249 More actions · Answer 4

I use Camtasia (camtasia.com).

Brian Knight
Free SQL Server Training Webinars

psmith-502573 SSC Enthusiast Points: 178 More actions · Answer 5

What kind of data operation restrictions does a view have? Are they strictly for schema objects or can you create views using temp table or table memory variables?

liebesiech SSCrazy Points: 2610 More actions · Answer 6

Like it as well. As I'm just moving from SQL Server 2K to 2K5 it also helps me to see how others work with the Management Studio.

Anipaul SSC-Insane Points: 24681 More actions · Answer 7

Brian Knight (7/31/2008)
You'll see a few of these a week. I've already sent SSC a dozen and another 30 will be sent to them by week end. We also have loads more for free on JumpstartTV.com

waooooo wonderful.....:)

Julie Breutzmann Hall of Fame Points: 3637 More actions · Answer 8

Thanks. Even thought I have created views before, I still learned some new tricks. I'm looking forward to other videos.

Julie

Jeff Moden SSC Guru Points: 1004312 More actions · Answer 9

What a great set of "mini-courses" you're in the process of having published! Nicely done!

My only question on this one would be... why would you ever teach anyone to do the Bozo-No-No of doing an ORDER BY in a view? 😉

--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)

odalee SSC Rookie Points: 40 More actions · Answer 10

Very cool indeed! Nice way to create and alter Views. As a beginning DBA, I found this work around very helpful. Thx! 😛

Jeff Moden SSC Guru Points: 1004312 More actions · Answer 11

Jeff Moden wrote:

What a great set of "mini-courses" you're in the process of having published! Nicely done! My only question on this one would be... why would you ever teach anyone to do the Bozo-No-No of doing an ORDER BY in a view? 😉

BWAAAA-HAAA!!! I guess I've waited long enough an for answer there. Moving on...

rofl

--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)