High Energy Plankton – T-SQL Tuesday #35
High Energy Plankton
In 2022 humans will finally have become their own worst enemies/frenemies. No matter how hard Gore works to...
2012-10-09
1,092 reads
Multiple CTEs
Multiple CTEs
It’s somewhat obscure in BOL and I wasn’t able to find any examples but it turns out you can...
2012-10-11 (first published: 2012-10-09)
4,596 reads
Part II - Louis Davidson (Dr SQL)–Designing for Common Problems in SQL Server…continued
The PASS Data Architecture Virtual Chapter will host part II of Designing for Common Problems in SQL Server by Dr....
2012-10-09
606 reads
Comments on the SQL in the City Tour
There’s still anevent in Seattle in a few weeks. As I’ve been traveling around the country, literally around through New...
2012-10-09
1,372 reads
T-SQL Tuesday #35 – Soylent Green
This month’s host is Nick Haslam (b | t) and he bases his question on the movie Soylent Green, which I...
2012-10-09
971 reads
Retrieving Driver Information
Recently, I had a need to take a look at all of the drivers for a specific set hardware on...
2012-10-09
453 reads
Interview with a #SQLPASS Candidate – @NTSSUG’s Sri Sridharan!
Last week, Sri Sridharan (Twitter, blog) and I sat down on the Internet to talk about his run for the...
2012-10-09
709 reads
MDS Error: “Cannot insert the value NULL into column ‘Code’”
In Microsoft Data Services (MDS), when running a stored procedure to process a staging table (stg.udp_name_Leaf), I received this error:
“Cannot...
2012-10-09
1,261 reads
My PASS Board Vote
I’m not a politically minded person and this is not the type of post I would normally write. However, I’m...
2012-10-09
778 reads
SQLSaturday #171 Pittsburgh recap
This past weekend I made the drive from Cleveland to Pittsburgh to attend SQLSaturday #171. They picked the perfect time...
2012-10-09
579 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
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