Answer -Question of the Week - 2/1/2014 - Question 1
Question :-
Suppose we have to design a database in which employees can work on multiple projects.There are many designation defined...
2014-01-10
1,313 reads
That Awkward Moment When I Started Channeling Brent Ozar
If you read my end-of-year post (you did, right?), you’ll recall that I mentioned that 2013 was a tough year...
2014-01-09
726 reads
January 2014 S3OLV and Tabular Models
This is really late notice. We had some extenuating circumstances this month and then a last minute cancellation. Now that everything is squared away, we have some great news....
2014-01-09
11 reads
January 2014 S3OLV and Tabular Models
This is really late notice. We had some extenuating circumstances this month and then a last minute cancellation. Now that...
2014-01-09
661 reads
Powershell in a Month – Day 8 Objects: data by another name
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-01-09
1,206 reads
Work Ethic and Family – A Tribute to My Parents
A tribute is an expression of gratitude or praise. A couple of years ago, I started a series about individuals...
2014-01-09
669 reads
Breaking Complex Data into Visualizations that Tell a Story
How much do you enjoy reading pages and pages of detailed report data? A large amount of information presented in...
2014-01-16 (first published: 2014-01-09)
3,065 reads
Free Online SQL Server Training for the Week of January 12, 2013
If you’re a training provider and I’ve missed you, please drop me a line at brian {dot} kelley {at} sqlpass...
2014-01-09
741 reads
Business Intelligence/Data Warehouse Assessment
When I am tasked to do a business intelligence or data warehouse assessment, the steps I take to do that...
2014-01-09
2,051 reads
Shutting down multiple servers with Powershell
I’ve recently helped a company move their infrastructure to a new data centre. Part of this involved shutting down a...
2014-01-09
564 reads
Blogs
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
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