SQL Saturday #130 Jacksonville Schedule Posted
SQL Saturday Jacksonville is just under a month away (April 28) and I’m happy to announce the we recently released...
2012-03-30
1,664 reads
SQL Saturday Jacksonville is just under a month away (April 28) and I’m happy to announce the we recently released...
2012-03-30
1,664 reads
About 3 weeks to go until SQLSaturday #107 at YES Prep Public Schools - North Central Campus, 13703 Aldine-Westfield, Houston, TX,...
2012-03-29
1,343 reads
Starting next week, that’s the first week of April, this will be my new office. Well, not really, but I’ll be working for the company that hosts this coaster,...
2012-03-29
31 reads
My New Office
Starting next week, that’s the first week of April, this will be my new office. Well, not really,...
2012-03-29
1,753 reads
Today morning I was working on one of the server to complete the regular documentation of security audit with details...
2012-03-29
1,975 reads
I will be a busy little beaver today, presenting three sessions at the Spring 2012 Connections Conference, the first one...
2012-03-29
1,764 reads
Your ability to document thoroughly will determine your efficiency and productivity when it comes to managing your SQL Server databases....
2012-03-29
2,756 reads
One of the problems with databases in SQL Server is the dependency of the database on various parts of the...
2012-03-29
2,019 reads
You can easily import data from an Excel file to SQL Server using SQL Server Import and Export Wizard. However,...
2012-03-29
3,333 reads
While preparing a demo for a presentation, I generated a 18456 error in the SQL instance by selecting a non-existent...
2012-03-29
1,181 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