ColoradoSQL–April 2012
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2012-04-17
846 reads
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2012-04-17
846 reads
Last week the SQL community and in particular the blogosphere, was buzzing with interest noise following the Microsoft Learning site...
2012-04-17
894 reads
I did a webinar during the 12 days of 2012 on how to use Report Builder 3.0. In this webinar...
2012-04-16
1,475 reads
In SQL Server 2012, we have a new feature: partially contained databases. In a previous post, I showed how to...
2012-04-16
12,438 reads
I particularly enjoy SQL Saturdays in Atlanta for a few reasons. It gives me an excellent excuse to come out...
2012-04-16
702 reads
I will be speaking at the Houston SQLSaturday this upcoming Saturday (April 21st). Below is info on my session, which...
2012-04-16
635 reads
I suppose there is an almost limitless number of mistakes that managers can do and do make, it’s the nature...
2012-04-16
1,027 reads
There are few memes going around in the SQL world. Probably the most popular of them is TSQL Tuesday (#tsql2sday)....
2012-04-16
1,809 reads
Just got the email, Orlando will be having its sixth annual SQLSaturday this year on September 29th, 2012, at Seminole...
2012-04-16
574 reads
I believe that service broker is one of the best features from SQL server 2005, well along with the xml...
2012-04-16
2,522 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...
Jl. Zainul Arifin No.78, Sukoharjo, Kec. Klojen, Kota Malang, Jawa Timur 65118
Jl. Thamrin No.8, Lawang, Kec. Lawang, Kabupaten Malang, Jawa Timur 65211
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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