SSWUG Expo..I'm up!
I am proud to say that one of the webcasts I taped last year for SSWUG is part of the...
2012-04-26
341 reads
I am proud to say that one of the webcasts I taped last year for SSWUG is part of the...
2012-04-26
341 reads
Here's the slide deck and sample files from last night's presentation at the Hammond .net User Group. We discussed SQL...
2012-04-26
985 reads
It is hard to believe, but SQL Server 2012 has been GA for nearly a month now. Because of this,...
2012-04-26
2,714 reads
It’s been a long time, almost a year since Andy Warren and I kicked off The Mentoring Experiment. We had...
2012-04-26
937 reads
I just found a little bug in AlwaysOn. It’s actually not that big a deal, but it’s interesting. In a...
2012-04-26
1,256 reads
http://www.flickr.com/photos/rohicks/4788477593/
Hello Dear Reader, this Saturday April 28th is SQL Saturday 130 in Jacksonville FL! The good people from the Jacksonville...
2012-04-26
905 reads
This past weekend I (w|t) headed up to Madison, WI to attend and present at SQL Saturday 118. The MADPASS...
2012-04-26
1,012 reads
A while ago Robert Cary posted an article on SQL Server Central entitled 2005 Paging – The Holy Grail which is,...
2012-04-26
2,049 reads
Enterprise Data Warehouse Architecture Options
Of course, your architecture depends on your business requirements along with technical, historical, and political factors....
2012-04-25
4,294 reads
Symmetric keys in SQL Server are recommended for encrypting data in columns. They are a good balance of security and...
2012-04-25
12,618 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