Fun with PowerShell: I made a game
So we got to playing around with PowerShell last week – one son is making a game hack, and the other...
2018-11-19
232 reads
Query Store and Plan Cache Plans Compared
Query Store plans and the plans in cache are identical, right? There won’t be differences because the plan that is...
2018-12-03 (first published: 2018-11-19)
2,026 reads
SQL Live Conference – December 2-7 in Orlando
I am proud to contribute to this year’s Live360 conference, to be held in Orlando Florida at the Royal Pacific...
2018-11-19
178 reads
Running SQL Server with Docker on the Mac
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-12-03 (first published: 2018-11-19)
2,710 reads
Dealing with multiple AD accounts
To help promote the seperation of duties one of the things my company has done is to divide our permissions...
2018-11-29 (first published: 2018-11-19)
2,416 reads
What is the SQL Server Trustworthy database property?
I ran across an interesting property set in a SQL Server database for a customer, the property is called “Trustworthy”. ...
2018-11-29 (first published: 2018-11-19)
26,791 reads
2018-11-19
19 reads
2018-11-19
5 reads
T-SQL Tuesday 108 – A poetic summary
This is November and T-SQL Tuesday time,
I hope you are ready to read the summary – I am the host and...
2018-11-19
189 reads
PASS Summit 2018 - Photos
My album of people and events at Summit 2018. Somehow a number of photo opportunities were missed!
[foogallery id=“1880”]
2018-11-19
11 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