Building an Intel Ivy Bridge Desktop System, Part 1
I stopped by my local Micro Center on April 9, 2012, and I noticed that they had just received their...
2012-04-11
1,311 reads
I stopped by my local Micro Center on April 9, 2012, and I noticed that they had just received their...
2012-04-11
1,311 reads
One of the problems with hashing is that you can have collisions from values that are not very similar. This...
2012-04-11
4,397 reads
I blogged previously that when you are a consultant or contractor, you can sometimes be faced with the decision when...
2012-04-11
5,574 reads
As the euphoria of SQLBits X sadly begins to fade, I wanted to take a moment to share with you...
2012-04-11
1,067 reads
There are situations where you need to grant SELECT permission to a particular user and limit that access to a...
2012-04-11
2,533 reads
Has someone deleted a table?
Are you trying to track auto grow events? Problem scenarios such as Database autogrow and slow...
2012-04-11
1,079 reads
Everyone heard about Facebook’s recent purchase of Instagram for $1 billion dollars. No one can imagine how they came with such...
2012-04-11
899 reads
With the release of the 22nm Ivy Bridge microarchitecture less than three weeks away, at the end of April 2012,...
2012-04-13 (first published: 2012-04-10)
3,253 reads
A while back, my young son thought it would be fun to use a CD as a virtual surfboard on...
2012-04-10
1,586 reads
XMLA can be used to manage the structure of your multidimensional databases. While many developers use Visual Studio (BIDS), to...
2012-04-10
732 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