Installing SSAS 2012
I don’t usually write posts like this but there have been a few substantial changes to how SSAS 2012 is...
2012-05-07
8,368 reads
I don’t usually write posts like this but there have been a few substantial changes to how SSAS 2012 is...
2012-05-07
8,368 reads
Denali – Day 6: indirect Checkpoint
I have already blog some information about checkpoint here
As I have already blog about Checkpoint and...
2012-05-06
1,573 reads
Using Replication Management Objects, SQL Server subscriptions can be synchronized programmatically without using SQL Server Agent or SQL Server Management...
2012-05-06
2,039 reads
I blogged a while back about not having the ability to easily disable purchasing on the Kindle. Until recently we...
2012-05-05
499 reads
Things have been quiet around here lately and I have a one word explanation….SQLRally. There’s work and family and several...
2012-05-05
597 reads
Denali – Day 5: Column-store indexes (aka Project Apollo)
There is another great achievement for Denali, especially for Data warehouse, where data...
2012-05-05
829 reads
I am not one of these anti PC sorta guys, but I do love my MacBook Pro. I have owned...
2012-05-05
655 reads
She Can Dig It!
A while back I was asked, if you can use the plan cache to determine which plans...
2012-05-04
1,452 reads
It was a little over a year ago that I stood on stage at the Rocky Mountain Tech Trifecta and...
2012-05-04
1,223 reads
In Part 1 of this series, we looked at SCD Type I. We would now look at the SCD Type...
2012-05-04
774 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