T-SQL Tuesday #88: My Top WTF Moments
Welcome to T-SQL Tuesday #88 being hosted this month by Kennie Nybo Pontoppidan (blog|@KennieNP). This month’s topic is the “daily...
2017-03-14
609 reads
Welcome to T-SQL Tuesday #88 being hosted this month by Kennie Nybo Pontoppidan (blog|@KennieNP). This month’s topic is the “daily...
2017-03-14
609 reads
In this module you will learn how to use the Stars Power BI Custom Visual. The Stars visual is a...
2017-03-14
854 reads
This month’s T-SQL Tuesday – hosted by Kennie T Pontoppidan(@KennieNP) – is called “The daily (database-related) WTF“. He asked us to be...
2017-03-27 (first published: 2017-03-14)
2,794 reads
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-03-24 (first published: 2017-03-14)
1,898 reads
Problem
Most DBAs are aware that (prior to SQL 2016) one of the most common, post installation changes that needs to...
2017-03-28 (first published: 2017-03-14)
6,024 reads
Last month Google announced the public beta for Cloud Spanner, and I would like to share few details around this since it’s a big news! So, what exactly is...
2017-03-14
24 reads
Last month Google announced the public beta for Cloud Spanner, and I would like to share few details around this...
2017-03-14
800 reads
The title is adapted from a child-hood movie of mine and is my daily (database-related) WTF moment and it is...
2017-03-14
388 reads
[read this post on Mr. Fox SQL blog] Like probably every SQL DBA, consultant, architect etc etc out there that has ever worked on or used SQL Server they will likely have...
2017-03-13
24 reads
[read this post on Mr. Fox SQL blog]
Like probably every SQL DBA, consultant, architect etc etc out there that has ever worked...
2017-03-13
1,553 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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...
Jl. Zainul Arifin No.78, Sukoharjo, Kec. Klojen, Kota Malang, Jawa Timur 65118
Jl. Thamrin No.8, Lawang, Kec. Lawang, Kabupaten Malang, Jawa Timur 65211
Has anyone ever seen this before? I have sysadmin permission on a server. 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 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