PowerPivot for Excel Install Issues
At one of my customers, we had a very frustrating experience while trying to get PowerPivot for Excel (SQL Server...
2012-02-02
994 reads
At one of my customers, we had a very frustrating experience while trying to get PowerPivot for Excel (SQL Server...
2012-02-02
994 reads
As some of you know, I am really excited about the data appliances Microsoft and HP have released this year. ...
2012-01-27
643 reads
In my previous blog, I introduced the “X on XMLA” series. In this blog, I will do more of an...
2012-01-26
672 reads
XMLA or XML for Analysis is used in SQL Server Analysis Services and other multidimensional data systems to manage the...
2012-01-19
549 reads
On Tuesday night was the first meeting for PASSMN, the SQL Server User Group in Minneapolis/St. Paul this year. As...
2012-01-18
588 reads
A tribute is an expression of gratitude or praise. As I head into this holiday season I wanted to express...
2011-12-20
524 reads
A fellow blogger and SQL guy, Jason Strate (@stratesql) started a meme on Social Networking as a result of a...
2011-12-15
576 reads
When I started looking into the upgrade path for this, I saw a couple of notes online about the fact...
2011-12-05
806 reads
Come join me and other Business Intelligence professionals at the Microsoft BI User Group meeting at Microsoft’s new offices in...
2011-12-02
466 reads
SQL Saturday 99 on Friday is upon us. I look forward to seeing you at the event. For details check...
2011-11-08
411 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Comments posted to this topic are about the item Pay for Performance, which is...
I wrote about this several years ago but will contribute again a life hack...
Hi I have this query that is slow during the 'not in' part of...
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 one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers