Fun with a String
I recently had a friend contact me recently to ask for some help with TSQL. The basic issue is that he had 2 tables. Table 1 has numeric key...
2011-01-06
19 reads
I recently had a friend contact me recently to ask for some help with TSQL. The basic issue is that he had 2 tables. Table 1 has numeric key...
2011-01-06
19 reads
Adam Machanic (@AdamMachanic) asked on Twitter if people who aren’t planning on attending PASS SQLRally should still vote for sessions...
2011-01-05
817 reads
Adam Machanic (@AdamMachanic) asked on Twitter if people who aren’t planning on attending PASS SQLRally should still vote for sessions on the schedule. My answer is a resounding...
2011-01-05
14 reads
In our original plan for PASS SQLRally we had set this week as the week to start voting for sessions. ...
2011-01-04
378 reads
In our original plan for PASS SQLRally we had set this week as the week to start voting for sessions. Unfortunately we are having to push back the voting...
2011-01-04
14 reads
I was “inspired” to write this post after I read some comments on my last post, Reviewing My 2010 Goals,...
2011-01-03
460 reads
I was “inspired” to write this post after I read some comments on my last post, Reviewing My 2010 Goals, and I read Brent Ozar’s post, Goals? Where we’re...
2011-01-03
13 reads
You can go over my goals here. I’ve really hesitated to do this post because, in my opinion, I did...
2010-12-30
1,428 reads
You can go over my goals here. I’ve really hesitated to do this post because, in my opinion, I did so poorly. Here’s what I did: Community ...
2010-12-30
14 reads
Well, we have 3 days left in the PASS SQLRally Call for speakers and we are doing well. We have over...
2010-12-13
333 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