When Will You Upgrade to SQL Server 2012?
This is a reprint from my editorial in Database Weekly. Also, check out the May Question of the Month, as...
2012-05-01
1,271 reads
This is a reprint from my editorial in Database Weekly. Also, check out the May Question of the Month, as...
2012-05-01
1,271 reads
This is in response to yesterday’s Twitter conversation, and subsequent blog by Eddie Wuerch, about submitting to more than one...
2012-05-01
797 reads
Denali — Day 1: Tempdb Compatibility – Bug?
I have installed sql server 2012 express and evolution edition on my personal laptop, and...
2012-05-01
475 reads
I hear you. You’ll use the Execute Package Task. This mechanism of executing one package from another is popularly knows...
2012-05-01
2,200 reads
Sequences are a new object in SQL Server 2012 that generate just what the name implies: a sequence of numbers....
2012-05-01
2,996 reads
In my daily job as a SQL Server consultant I go to a lot of places, many days on the...
2012-05-01
8,875 reads
As part of my ongoing effort to teach by bad example and pass on what little I’ve learned about programming...
2012-05-01
3,564 reads
When I attended SQL Saturday #131 at the Chandler Gilbert Community College, I was struck by a few design elements...
2012-04-30
2,007 reads
This past weekend I attended a SQL Saturday in the desert. SQL Saturday #131 was held in Phoenix, AZ
It’s April,...
2012-04-30
1,925 reads
I wrote a store procedure which could generate restore script automatically by backup history table. it can help you select...
2012-04-30
7,020 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