PowerPivot for Excel Now 2012 Only
I’m not exactly sure when this happened, but it looks like Microsoft has moved past the PowerPivot 2008R2 and PowerPivot...
2012-07-17
885 reads
I’m not exactly sure when this happened, but it looks like Microsoft has moved past the PowerPivot 2008R2 and PowerPivot...
2012-07-17
885 reads
With the Office 2013 announcements today I was excited to download and get my hands on the tools. Because this is still...
2012-07-18 (first published: 2012-07-17)
3,308 reads
Crystal Reports has a special field name “DataDate”. This date shows the last time the data on the report has...
2012-07-16
1,390 reads
Today I have decided to prepare myself for a meeting with a potential client (tomorrow) and write an article about...
2012-07-16
642 reads
With a little help from the Kimball Group, I have become somewhat knowledgeable with the Data Mart dimension model approach...
2012-07-16
869 reads
It’s a wrap. Two days of SQL in the City are complete, and I’m back at home, almost feeling normal....
2012-07-18 (first published: 2012-07-16)
3,083 reads
Today a friend Kevin Edward Kline announced he was joining SQL Sentry. Last week Kevin announced his intent to leave...
2012-07-16
555 reads
LinkedIn is a great resource to improve your career. It has definitely worked for me as the last 5-6 jobs I have...
2012-07-20 (first published: 2012-07-16)
3,914 reads
We’ve been slacking for way too long, but as of this week our video RSS feed is up to date!...
2012-07-16
706 reads
Last time we went over the basics of creating a SQL Audit. Now obviously once you’ve gotten your audit in...
2012-07-19 (first published: 2012-07-16)
3,271 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