Interesting Case of SSIS Failures
Interesting Case of SSIS Failures
We had an interesting case of SSIS failures recently where the cause ended up being improved...
2010-06-10
1,082 reads
Interesting Case of SSIS Failures
We had an interesting case of SSIS failures recently where the cause ended up being improved...
2010-06-10
1,082 reads
T-SQL Tuesday # 07: Walkthrough for Sysprep in SQL Server 2008 R2
This blog entry is participating in T-SQL Tuesday #007, hosted...
2010-06-08
4,951 reads
Taking a Medical Approach to Performance Troubleshooting
I find it difficult sometimes to explain to someone how to have a take...
2010-05-31
2,666 reads
Are you a DBA? You might Be!
On Twitter, people do a lot more than gossip and post messages about mundane,...
2010-05-29
2,524 reads
Study Tips for the SQL MCM Exams
I met the new rotation of the SQL Server Certified Master program on Friday....
2010-05-16
2,186 reads
Question: Is Mirroring Supported by MS Access front-end?
The following question was posted on a SQL Server discussion group. My reply...
2010-05-07
2,321 reads
The Toilet Analogy … or Why I Never Recommend Increasing Worker Threads
Lately I’ve noticed an increasing number of people recommend increasing...
2010-05-07
6,261 reads
A Few Updates on the MCM: Plaques, Visitors, New Class, and New MCM’s
I just want to pass along a few...
2010-05-01
1,166 reads
Undocumented Capabilities of Extended Event Objects
The extended event objects (objects exposed by an event package) are listed in the system...
2010-04-28
2,186 reads
Looking forward to Optimize for Ad hoc Workloads in Sql Server 2008
One of the features of SQL Server 2008 that...
2010-04-23
3,278 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