Why you *can't* provide your Facebook credentials
I know this isn't related to SQL Server, but it is related to security and privacy.
If an employer or...
2012-04-02
2,417 reads
I know this isn't related to SQL Server, but it is related to security and privacy.
If an employer or...
2012-04-02
2,417 reads
Like all systems built on top of SQL Server SharePoint 2010 needs to have a plan for availability. There are...
2012-04-02
1,239 reads
I got an email today from the SQL Saturday #131 crew with the schedule posted, showing me listed for two...
2012-04-02
943 reads
My co-worker showed me an easy way to process all SQL Server Analysis Services (SSAS)cube dimensions (or measures) from the...
2012-04-02
4,362 reads
My previous blog, SQL Server 2012 (“Denali”): Details on the next version of SSAS, talked about the major new feature in...
2012-04-02
2,702 reads
Nine months down, three to go*. It’s time once again to see where I’m at with the goals I set...
2012-04-02
980 reads
Today’s post is something I thought I would share as there is an awful lot of incorrect commands I have...
2012-04-02
842 reads
Stress affects everyone, but it’s easy to forget that. Once you get sensitized to it, it’s amazing to pick up...
2012-04-02
740 reads
While presenting a session on Common Backup Problems both at SQL Saturday in Orange County and at SQL Connections in...
2012-04-02
1,066 reads
On more than one occasion, I have run into a case where a large database with a large transaction log was being mirrored. Then a hiccup comes along –...
2012-04-02
25 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