TSQL Tuesday #84: Zip to Speaker
Well, it’s that time of the month again. It’s T-SQL Tuesday yet again, and this time round it’s Andy Yun (b/t)...
2016-11-08
470 reads
Well, it’s that time of the month again. It’s T-SQL Tuesday yet again, and this time round it’s Andy Yun (b/t)...
2016-11-08
470 reads
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
Related Posts:
Summiting that Technical Challenge January 9, 2018
Connect To SQL Server - Back...
2016-11-08
29 reads
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-11-08
538 reads
This month's #tsql2sday is being hosted by Andy Yun (b|t) and is about helping new speakers.
I have only been speaking...
2016-11-08
233 reads
When you want to change configuration settings for your SQL Server you would either do it via Management studio (under...
2016-11-08
718 reads
Do you know that your Server logs 300 million deprecation events a week? Do you know if code needs to be updated or how to find deprecated uses in...
2016-11-07
21 reads
How well do you know your environment? You probably know all of the jobs that are running, the frequency that...
2016-11-07
2,054 reads
I spent a good bit of time looking for the definitions/descriptions of the TMSCHEMA DMVs that allow us to view...
2016-11-07
778 reads
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch...
2016-11-07
49 reads
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2016-11-07
821 reads
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
Comments posted to this topic are about the item Data Lost in the Cloud
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 two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers