T-SQL Tuesday #37 – A Month of Joins
It’s time once again for T-SQL Tuesday, and this month is hosted by SQLity.net, Sebastian Meine.
If you want to know...
2012-12-11
1,496 reads
It’s time once again for T-SQL Tuesday, and this month is hosted by SQLity.net, Sebastian Meine.
If you want to know...
2012-12-11
1,496 reads
I was reading a blog post by Steve Jones on Monday and I started to write a comment on his...
2012-12-11
1,109 reads
You may have noticed in my code examples, I always include a semicolon ";" at the end of my TSQL statements. ...
2012-12-11
1,057 reads
Hey Friends,
Sometime we may feel the need to move SharePoint site collection to new content db. Below step can be...
2012-12-11
987 reads
Just wanted to get the word out that our SSRS 2012 training course is available. Are you looking for expert...
2012-12-10
1,540 reads
An Updated list of all the topics.
I was looking for a static list of all the T-SQL Tuesday topics and...
2012-12-10
1,619 reads
Did you know you can copy and paste connection managers in SSIS? While I haven’t found this a huge benefit...
2012-12-10
1,581 reads
Due to the huge demand of SQL Server Troubleshooting Know How and Techniques I’m running on January 29 (Vienna/Austria) and...
2012-12-10
1,210 reads
Due to the huge demand of SQL Server Troubleshooting Know How and Techniques I'm running
on January 29 (Vienna/Austria) and January...
2012-12-10
2,459 reads
It’s a bit past the first Monday in December, but better a week late than no checklist and update post...
2012-12-10
913 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...
Telp/Wa 628217555651 Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
Telp/Wa 62817825533 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
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