Pass Summit 2017
It’s about that time of year again when there is a buzz in Seattle in regards to PASS Summit. Many...
2017-10-26
423 reads
SQL Server Phantom Reads
With Halloween around the corner what better topic to discuss than phantom reads. A phantom read occurs when rows have...
2017-11-08 (first published: 2017-10-26)
1,632 reads
SQL Server – Concat_WS function in SQL Server 2017
Hello friends, Please find the link for my new article at below url – https://social.technet.microsoft.com/wiki/contents/articles/44327.sql-server-concat-ws-function-in-sql-server-2017.aspx Regards Kapil
2017-10-26
570 reads
IT Dev Connections 2017
The IT Dev Connections conference was in San Francisco, CA this week. While I did not spend any time as a tourist, I did mingle with attendees and speakers....
2017-10-25
13 reads
Configuring a Subscription to an Azure SQL
This is my first post where I utilize an hybrid cloud, item that I personally find very interesting and useful so expect more posts like this to come.Microsoft Azure...
2017-10-25
30 reads
Necessity is the Mother of Automation
If you have worked with me or are a frequent reader of my blogs or a frequent attendee of my...
2017-10-25
531 reads
Repair a Windows Server 2016 installation
This is more for my benefit in the future, but hopefully it can help someone else too. We recently had...
2017-10-25
4,511 reads
PASS Summit and Redgate Software
Next week is the PASS Summit. I’m so excited about it I could pop. Part of why I’m excited is...
2017-10-25
326 reads
Synchronous VS Asynchronous Statistics Updates
One of the things I’ve been able to implement to help with performance is changing from Update Statistics Synchronous to...
2017-11-07 (first published: 2017-10-25)
2,040 reads
Basic FORMATting– #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-10-25
1,189 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