Speaking at DataGrillen
After speaking at SQL Saturday Iceland last year, which is a smaller event that I absolutely loved (you can read...
2019-01-04
162 reads
Pro SQL Server on Linux–Getting Started
As part of my learning goals for 2018, I wanted to work through various books. This is part of my...
2019-01-18 (first published: 2019-01-04)
1,920 reads
Speaking at SQLBits
I got an early Christmas present this year, I found out I had been selected to speak at SQLBits! That’s what I call a gift that keeps on giving....
2019-01-04
17 reads
Speaking at SQLBits
I got an early Christmas present this year, I found out I had been selected to speak at SQLBits! That’s...
2019-01-04
157 reads
Azure – Backing up to URL
In a previous post, I talked about some of the available storage options that can be used to back up...
2019-01-14 (first published: 2019-01-04)
453 reads
Looking Forward
2018 has come and gone. And we’re on a new year once again. This is another opportunity for a new...
2019-01-04
267 reads
Query memory grants part 1: Where does the memory go?
Let’s talk about how queries use memory, specifically in the execution plan. One of the query operators that use memory...
2019-01-04
239 reads
Speaking at SQL Saturday Nashville
I am excited and honored to announce that I have been selected to speak at SQL Saturday Nashville on January 12, 2019. I’ve been to Nashville before, in fact...
2019-01-04
19 reads
Speaking at SQL Saturday Nashville
I am excited and honored to announce that I have been selected to speak at SQL Saturday Nashville on January...
2019-01-04
134 reads
Automatic Tuning Monitoring and Diagnostics
Thanks to Extended Events (XE), we have access to a guide of sorts that will help us better understand if our shiny new tool (automatic tuning) is operating as...
2019-01-04
40 reads
Blogs
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...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
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