SQL Tribal Knowledge needs editors!
A while back I invited the unpublished masses to submit abstracts for a new-author-written SQL book – called Tribal SQL – and the...
2012-03-21
665 reads
A while back I invited the unpublished masses to submit abstracts for a new-author-written SQL book – called Tribal SQL – and the...
2012-03-21
665 reads
In the last weeks and months I have prepared tons of SQL Server 2012 content for my
own SQL Server 2012...
2012-03-21
18,809 reads
If you ever find yourself having to setup database mirroring between different, untrusted Windows Domains, one of the most common...
2012-03-21
1,521 reads
Tomorrow at 11:30 CST Pam Shaw will be talking SQL Reporting Services (SSRS). If you have time, join us for...
2012-03-21
1,854 reads
Tomorrow at 11:30 CST Pam Shaw will be talking SQL Reporting Services (SSRS). If you have time, join us for...
2012-03-21
946 reads
When the Fast Track Data Warehouse 3.0 Reference Guide was published, it was based off of SQL Server 2008 R2....
2012-03-21
994 reads
Tomorrow, Thursday, March 22, 2012, the official Microsoft SQL Server 2012 Special Ops Tour continues its 12-city trek around the...
2012-03-21
1,752 reads
Microsoft has also released SQL Server 2008 SP3 Cumulative Update 4. This is Build 10.00.5775.00, and it has ten fixes...
2012-03-21
4,272 reads
Hello Dear Reader, this week finds me in beautiful Miami FL. Next week I’ll be in Vegas, for one night...
2012-03-21
664 reads
When I was growing up, we used to sit round the t.v. (families only had one in those days) and...
2012-03-21
772 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