Thank God I Chose SQL Server part I: The Tribulations of a DB2 Trial
My last column, Misadventures in TDE: How to Restore an Encrypted SQL Server Database Completely Wrong, described a comedy of...
2012-03-31
3,681 reads
My last column, Misadventures in TDE: How to Restore an Encrypted SQL Server Database Completely Wrong, described a comedy of...
2012-03-31
3,681 reads
I was just looking at the schedule for Houston, an amazing 10 tracks for this event on April 21, 2012....
2012-03-31
1,528 reads
TweetG’day,
I wrote a post recently about setting the DAC port for an SQL instance.
I now do this as a matter...
2012-03-31
1,906 reads
Here is a post I happen to find today: why select command is not blocked by update command?
http://blog.csdn.net/zjcxc/article/details/4383113
First, I...
2012-03-30
3,046 reads
I returned late last night from the Spring DevConnections event, delivering three sessions in the SQL Server Connections conference. I...
2012-03-30
2,694 reads
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-03-30
1,877 reads
BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server...
2012-03-30
2,548 reads
Recently I suffered through a frustrating and contentious meeting, and that was stressful. I needed a walk, a few minutes...
2012-03-30
1,627 reads
On a recent project I was asked to “upgrade” a licensed SQL Server 2008R2 Standard Edition to SQL Server 2008R2 Enterprise Edition....
2012-03-30
6,964 reads
Welcome to the show! I’ll be liveblogging today’s keynote here at SQLBits X in London.
There’s no need to refresh your...
2012-03-30
1,636 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