Licensing SQL Server Dev/Test Environments
I was recently at a client site and we started talking about SQL Server licensing, specifically for their development and...
2012-07-27
20,360 reads
I was recently at a client site and we started talking about SQL Server licensing, specifically for their development and...
2012-07-27
20,360 reads
SQL Server Team, has announced the Service Packe 2 available for the SQL Server 2008 R2.
All the details are here
Stay...
2012-07-27
1,411 reads
When SQL Server 2008 R2 was released several new Reporting Services expressions were made available that would help join multiple...
2012-07-27
4,391 reads
Checkout my article (i.e. Retrieving Deadlock Graphs with Event Notification) that is published on SSWUG.org. This article shows the steps...
2012-07-26
2,930 reads
One of the most basic capacity considerations involved while planning to move SQL workloads to a virtual environment is to understand the...
2012-07-26
850 reads
This is a topic that’s been well covered, but in the interest of spreading good database practices, here’s a very...
2012-07-26
1,135 reads
Our call for speakers for SQLSaturday #151 in Orlando closes on July 31, 2012. We’ve got room for a handful...
2012-07-26
620 reads
In the last 2 blog postings you have learned how to setup your first Availability
Group with SQL Server 2012. Today...
2012-07-31 (first published: 2012-07-26)
4,740 reads
A problem I see on a fairly regular basis is that of dealing with NULL values. Specifically here, where we...
2012-07-26
1,853 reads
I was called over today by a person doing application support to help troubleshoot a database connectivity issue. This isn't a...
2012-07-30 (first published: 2012-07-26)
2,752 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