Trim Functions in SSIS
In T-SQL there are many functions there to help do a variety of different things. SSIS is no different. In...
2012-03-23
2,026 reads
In T-SQL there are many functions there to help do a variety of different things. SSIS is no different. In...
2012-03-23
2,026 reads
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-03-23
791 reads
In an SSIS package you have the option to choose from a wide range of source from Flat Files to...
2012-03-29 (first published: 2012-03-23)
3,653 reads
As a follow-up to my blog Microsoft SQL Server Reference Architecture and Appliances, Dell recently announced the future availability of Dell Quickstart...
2012-03-23
1,325 reads
First thing this morning – a request from a DBA to confirm if Differential BACKUPS can be restored on a database...
2012-03-23
15,885 reads
Everybody loves the carnival. It only comes around every few years, but when it does, it brings in a variety...
2012-03-23
895 reads
Several months ago I described a solution for Delegated SQL Server Administration with Powershell. In the solution, the SqlProxy module...
2012-03-28 (first published: 2012-03-23)
6,072 reads
Are you ready for the round-up of last week’s #meme15 Facebook question?
In total, there were eight participants in this month’s...
2012-03-22
1,022 reads
When you run something from the start menu or in a Windows command prompt, you type the program name to...
2012-03-22
1,875 reads
The last step in our campaign to rid the world of maintenance plans deals with housekeeping: the history cleanup step....
2012-03-22
1,009 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