Business Intelligence Projects now supported in Visual Studio 2012
Since the release of Visual Studio 2012, business intelligence developers have been limited in how much they could use this...
2013-03-06
1,565 reads
Since the release of Visual Studio 2012, business intelligence developers have been limited in how much they could use this...
2013-03-06
1,565 reads
Generally, we try to find out records matching a certain criteria from a single or few tables. However, there are...
2013-03-06
1,033 reads
While working on some demos recently, I needed to drop an index for a test. I executed this generic statement...
2013-03-06
1,266 reads
What is Data Explorer
Data Explorer simplifies the data discovery phase for Excel users that are creating self-service Business Intelligence solutions. ...
2013-03-06
1,089 reads
While working with SSRS (SQL Server Reporting Service) it is very common to look into the Execution log to understand...
2013-03-06
2,602 reads
My most popular blog has been Visual Studio 2012 does not support BI. In short, this means VS 2012 does...
2013-03-06
2,832 reads
In the earlier post we tried to understand the difference between a table having clustered index and does not have a clustered...
2013-03-06
2,232 reads
I am working as the data architect and developer on a modern app build with a the team from Modern...
2013-03-06
1,018 reads
As I’ve worked with clients on performance tuning through index improvements, one of the common areas that I discuss with...
2013-03-06
2,449 reads
Do you have any plans in place to upgrade to SQL Sever 2012 this year. We are now well into...
2013-03-06
1,063 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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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...
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