Data Mining Part 38: Text Mining - The term lookup
In this new article, we will show how to use the SSIS term lookup transformation tool.
2016-04-27
2,036 reads
In this new article, we will show how to use the SSIS term lookup transformation tool.
2016-04-27
2,036 reads
This new chapter will show you how to work with the SSIS Data Mining Query Transformation Task
2016-04-14
2,580 reads
In this article we are going to look two new enhancements: the Insert snippet menu option and the surround with option.
2014-09-01 (first published: 2012-05-15)
18,773 reads
Sometimes we need to create backups using code. Sometimes we need to do it manually or automatically, programmatically using C#, VB, Powershell.
2012-08-14
7,715 reads
This article describes how to create user defined server roles and use stored procedures and queries related.
2012-05-25
4,649 reads
This article describe the problems about the migration of the databases and logins and the new feature contained databases
2012-05-22
10,907 reads
In this article I will run a SQL Server script to backup a database using C# in visual studio. For this purpose, I am going to use the sqlcmd.
2012-04-27
18,056 reads
In this article, we are going to create a linked server to the MySQL Database.
Once finished that task, we will select, insert, update and delete some data using SQL Server.
2012-04-17
10,004 reads
This article describes the sequence new feature used in SQL Server 2012
2012-04-13
9,498 reads
This article describes the use and advantages of the throw statement.
2012-04-03
2,770 reads
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Switching Schemas I
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
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 one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers