MVP Status: Renewed
On October 1, 2016, I was first honored by Microsoft with their prestigious MVP award, given to those that they feel have made a significant difference in their development...
2018-07-10
59 reads
MVP Status: Renewed
On October 1, 2016, I was first honored by Microsoft with their prestigious MVP award, given to those that they...
2018-07-10
261 reads
Code I Can’t Live Without–T-SQL Tuesday #104
Bert Wagner has a good invitation this month, a T-SQL Tuesday question about code, specifically code you can’t live without....
2018-07-19 (first published: 2018-07-10)
3,708 reads
Code I’d Hate To Live Without: T-SQL Tuesday #104
It’s TSQL Tuesday again! This time our respected host is Bert Wagner (b/t). Quick aside, if you haven’t seen his...
2018-07-19 (first published: 2018-07-10)
3,649 reads
Building Dynamic Table-Driven Queries
This post is a response to this month’s T-SQL Tuesday #104 prompt by me! T-SQL Tuesday is a way for...
2018-07-17 (first published: 2018-07-10)
3,623 reads
Building Dynamic Table-Driven Queries
This post is a response to this month's T-SQL Tuesday #104 prompt by me! T-SQL Tuesday is a way for SQL Server bloggers to share ideas about different database...
2018-07-10
30 reads
Building Dynamic Table-Driven Queries
This post is a response to this month's T-SQL Tuesday #104 prompt by me! T-SQL Tuesday is a way for SQL Server bloggers to share ideas about different database...
2018-07-10
16 reads
T-SQL Tuesday #104 – My Undercover Toolbox favourites
This months T-SQL Tuesday is being hosted by Bert Wagner , you can find the invitation for this months topic here.
Bert...
2018-07-18 (first published: 2018-07-10)
2,718 reads
Display SELECT query or table as HTML
This post is part of #tsql2sday event :)For my current job I support a lot of SQL Servers, they come...
2018-07-10
388 reads
T-SQL Tuesday #104 - Code You Would Hate To Live Without
This month’s T-SQL Tuesday is hosted by Bert Wagner and he asks us to write about code we’ve written that we would hate to live without.
First off, “hate” is...
2018-07-10
29 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