Improved Customer Support
In the last couple of months SQLTreeo has improved her customer contact skills. Before it was just an email to...
2013-09-13
832 reads
In the last couple of months SQLTreeo has improved her customer contact skills. Before it was just an email to...
2013-09-13
832 reads
Sometimes below error occurs on our web applications hosted on IIS connected with SQL Server.
Timeout expired. The timeout period elapsed...
2013-09-13
32,357 reads
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2013-09-13
542 reads
Today morning when I was working on a huge database containing lots of LOB data, I was required to know...
2013-09-12
890 reads
Two new TPC-E benchmark results have shown up for two-socket database servers using the brand new, 22nm Intel Xeon E5-2697...
2013-09-12
1,703 reads
September is a wild month for me! This Saturday, September 14th, I will be at Kansas City’s next SQL Saturday #191...
2013-09-12
743 reads
The Certified Master and Architect community was collectively notified Friday, August 30, at 10PM PST that the Certified Master (MCM/MCSM)...
2013-09-12
1,513 reads
Didn’t they just do this in the spring? Word is out that they’re expanding even more data centers. The cynical...
2013-09-12
681 reads
It’s day four of our six part series Introduction to Integrity, sponsored by Idera, and tonight’s topic is going to...
2013-09-12
1,152 reads
The second incarnation of 2013 “SQL Relay” is bigger and better than ever. We have taken on board all of...
2013-09-12
681 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
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...
Comments posted to this topic are about the item Data Lost in the Cloud
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