Adding a Computed Column to a Table (1) - SQL School Video
In this SQL School video, Andy Warren shows how you can alter a table to add a computed column. This is part 1 of 2.
2009-06-23
4,689 reads
In this SQL School video, Andy Warren shows how you can alter a table to add a computed column. This is part 1 of 2.
2009-06-23
4,689 reads
Saw this in email this morning, Clear has ceased operations after failing to negotiate with its senior creditor. I’ve written...
2009-06-23
636 reads
As happens occasionally I had a stack of books on my desk that needed to be put away, and as...
2009-06-23
537 reads
Yesterday I posted Part 1 containing five ideas for those looking for work. Today I’m going to focus on what to do when you’re struggling to get interviews. Your chances of getting hired for any given job once you interview are perhaps 1 in 10 (an unscientific...
2009-06-23
2,333 reads
My friend Robert Cain was kind enough to include me on his list of big thinkers along with my business...
2009-06-22
816 reads
Getting a job is hard. If you’ve been lucky enough not to struggle for a job, don’t make the mistake...
2009-06-22
1,232 reads
I think the hardest part about the job search is interviewing and not being selected. You keep saying “why” with...
2009-06-22
623 reads
Learn how you can create your own data types in this SQL School video. MVP Andy Warren explains the process of setting up user-defined data types.
2009-06-18
3,986 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-06-18
667 reads
As I've related previously (Part 1, Part 2, Part 3, Part 4, Part 5) I've been working author and speaker Don Gabor on my networking skills. We recently did our final call of the six hours coaching planned, and thought I'd share some final thoughts.
2009-06-18
1,274 reads
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Switching Schemas I
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers