BCM - 数据库开发

三招搞挂MySQL

John — Sun, 22 May 2016 05:02:54 +0000

本文将介绍三种搞挂MySQL的方式，逗大家一乐，同时也会揭露一些MySQL使用过程中的注意事项和实现原理，以供参考。感兴趣的同学可以找一个MySQL实例进行测试。我要说的三种方式分别是：产生大量undo日志撑满磁盘空间导致MySQL不可用；定义大量用户变量耗尽MySQL的 ...

数据清洗工具OpenRefine

瀚文 — Fri, 16 May 2014 09:14:45 +0000

数据经常被称为一座金矿，尤其是在当今数据驱动的经济环境下更是如此。怎样把数据集在OpenRefine中进行转换，优化数据的质量以便于在真实场景下重用它们。一、介绍OpenRefine 我们来看一个残酷的现实：你的数据是杂乱无章的。错误会散步到你的大数据集中，无论你有 ...

应该在什么时候使用Hadoop

瀚文 — Fri, 16 May 2014 09:12:10 +0000

有人问我，“你在大数据和Hadoop方面有多少经验？”我告诉他们，我一直在使用Hadoop，但是我处理的数据集很少有大于几个TB的。他们又问我，“你能使用Hadoop做简单的分组和统计吗？”我说当然可以，我只是告诉他们我需要看一些文件格式的例子。他们递给我一个包含60 ...

Executing SSIS Packages from command prompt / SSMS

demo — Wed, 17 Oct 2012 21:42:25 +0000

“Dtexec” utility can be used to run the SSIS packages from the command prompt. Using dtexec utility you can load packages from a Microsoft SQL Server database, the SSIS service, and the file system. The general syntax isWhen a package runs, dtexec ...

Export data from SQL Server2000 to Excel besides BCP

demo — Fri, 24 Aug 2012 20:44:36 +0000

Apart from using DTS and Export wizard, we can also use this query to export data from SQL Server2000 to Excel Create an Excel file named testing having the headers same as that of table columns and use these queries 1 Export data to existing EXCEL

How to export a table with a header using bcp

demo — Fri, 24 Aug 2012 20:17:20 +0000

I swear that\'s what was posted. Mostly they want a header row in their data and they didn\'t want to use DTS... bcp out with column names post OK, here you go..probably need to deal with more datatype than I have accounted for...http://weblogs.sqltea

SEQUENCE in SQL Server 2012

Southhill — Tue, 13 Mar 2012 16:23:00 +0000

SQL Server 2012 (or Denali) has now arrived CTP. In thisarticle I will look at a core new feature of SQL Server 2012 which is SEQUENCE.Well, if you are familiar with Oracle, you will already know all about thisfeature since it has been standard on Or ...

Bulk Insert SQL Using Format File and Fixed Width Text File

Test — Thu, 06 Oct 2011 21:46:58 +0000

Here is an example: Let\'s say the fixed width text data file as: This file created under Linux and only has 0xD(\\n) to make a new line. and we create a format file like this: Please note the date data inside the source text file is as MM/DD/YY

Using SQL Bulk Load to Upload Fixed Width Text Files

Test — Wed, 05 Oct 2011 21:00:04 +0000

Introduction The class needs a table on a SQL Server somewhere to import into, a connection to that database, a file to load, the names of the fields to load the data into and the possessions in the file to load. I set this up so that everything can ...

VBA: Select and Special Select functions

Test — Thu, 15 Sep 2011 23:27:45 +0000

Try the code bellow, you can see the different selection pf cells.

VBA: Finding the record(s) in RecordSet

Test — Thu, 15 Sep 2011 22:31:48 +0000

Finding a Record Based on Multiple Criteria Finding Records Using the Find Method Finding a Specific Record in a Recordset Finding the Record Position Change column data case SQL with where clause NoMatch property in Recordset

SQL Server Excel Workbench

John — Thu, 01 Sep 2011 18:28:22 +0000

/*The need to produce Excel reports from SQL Server is very common. Here, Robyn Page and Phil Factor present practical techniques for creating and manipulating Excel spreadsheets from SQL Server, using linked servers and T-SQL. The pièce de résista ...

Where Vs Having / Difference between having and Where clause

Test — Wed, 24 Aug 2011 18:05:09 +0000

Introduction We always get confused between WHERE and Having clause and make mistakes. Here in this article, I will try to highlight all the major differences between WHERE and HAVING, and things you should be aware of, when using either WHERE or HA ..

T-SQL RANK() , DENSE_RANK() , NTILE(), ROW_NUMBER()

Test — Wed, 24 Aug 2011 17:35:51 +0000

Rank(): Returns the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks that come before the row in question. Usage: RANK ( ) OVER ( [ < partition_by_clause > ] < order_by_clause > ) Dense_R

Sample code for DecisionPlus - Read in csv data

Test — Tue, 23 Aug 2011 22:42:06 +0000

Usually we can just use DecisionPlus to do it. just as example here: But Linux already has very strong capability on text processing, so I tried to use script to get data and only pass the data been read out to the DecisionPlus program. like we hav