Workspace database server was not found
You might constantly see a warning message that appears like the one below when creating Analysis Services Tabular projects. It...
2012-05-08
1,115 reads
You might constantly see a warning message that appears like the one below when creating Analysis Services Tabular projects. It...
2012-05-08
1,115 reads
It’s been just over two months since I started my small home garden. The initial work to clear the area...
2012-05-08
668 reads
In some database designs, you may encounter SQL Server columns with a TIMESTAMP or ROWVERSION data type. What are these, and how do you deal with them in SQL...
2012-05-08
692 reads
Last week we blogged about “How to configure Database mail” – this week we’ll have a closer look at what to...
2012-05-08
9,844 reads
Everyone who is involved in, and follows me in the SQL Server Community, and my blog, knows, that I am one...
2012-05-11 (first published: 2012-05-08)
3,180 reads
In some database designs, you may encounter SQL Server columns with a TIMESTAMP or ROWVERSION data type. What are these,...
2012-05-14 (first published: 2012-05-08)
8,019 reads
They say, “April showers bring May flowers.” But what if it doesn’t bring May flowers? What if instead you get...
2012-05-08
845 reads
A post more for me than for anyone else, since I’ll look for something in the default trace and I...
2012-05-07
15,835 reads
One type of error that arises occasionally during SSAS cube processing is the ‘duplicate attribute key’ error. The error message...
2012-05-07
1,357 reads
The SQL Server Team Blog is in the midst of posting twelve, short weekly videos that let someone from the...
2012-05-07
1,051 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