Master Data Services: Changing a model with a subscription view
I have been working heavily with Microsoft Data Services (MDS) in SQL Server 2012 over the past few months, and...
2012-09-10
2,647 reads
I have been working heavily with Microsoft Data Services (MDS) in SQL Server 2012 over the past few months, and...
2012-09-10
2,647 reads
A few years ago I went to Seattle a few days before the PASS Summit started. I took my middle...
2012-09-14 (first published: 2012-09-10)
1,911 reads
Recently I needed to help a colleague with a small inventory true up task. We needed to know items that...
2012-09-10
812 reads
location: AppendOnlyVerStoreMgr.cpp:776
Expression: 0
SPID: 64
Process ID: 4912
Description: Cannot locate version record and page is not allocated. Status = 3
Msg 3624, Level 20,...
2012-09-10
1,368 reads
COLORADO SPRINGS SQL
September 19, 2012 at 5:30 p.m.
Meeting Location: Hyatt Place - Garden of the Gods, 503 West Garden of the Gods...
2012-09-10
884 reads
Back on August 15th I did a webinar for the PASS Professional Development virtual chapter on my talk Being the...
2012-09-10
1,142 reads
A lot of a DBA’s time is spent managing and investigating transaction log files.
A commonly used tool is the command:
DBCC...
2012-09-10
2,802 reads
TweetG’day,
Sometimes I come across what I call unusual coding practices. Developers usually have pressure on them to deliver and this...
2012-09-12 (first published: 2012-09-10)
2,405 reads
As a database administrator I get lots of security requests. “Please grant me read authority on this table, write on that table,...
2012-09-10
756 reads
Today I encountered a interesting issue when rename logical name for mirror database.
We have a database which has been setup...
2012-09-14 (first published: 2012-09-09)
3,094 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...
Wa:082374977784 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
Wa:082374977784 Jl. Jenderal Sudirman Lt Dasar, RT.1/RW.3, Gelora, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
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