IT Minds

HOW TO MODIFY A COLUMN SIZE, IF WE HAVE MULTIPLE TABLES WITH DIFFERENT SUFFIX AND THAY ALL CONTAINS SAME COLUMN DEFINITIONS, I NEED TO MODIFY A SPECIFIC COLUMN'S SIZE OF ALL TABLES USING ONE SCRIPT.  AS LIKE MENTIONED BELOW: UPDATE  INFORMATION_SCHEMA.COLUMNS SET  CHARACTER_MAXIMUM_LENGTH = 100, CHARACTER_OCTET_LENGTH = 100 WHERE  TABLE_NAME LIKE '__MYTABLENAME' AND  COLUMN_NAME = 'MYCOLUMNNAME' AND  CHARACTER_MAXIMUM_LENGTH < 100 ---------------------------------------------------------------------------------------------------------------------------------- Using OPENROWSET to read large files into SQL Server Problem OPENROWSET is a T-SQL function that allows for reading data from many sources including using the SQL Server's BULK import capability. One of the useful features of the BULK provider is its ability to read individual files from the file system into SQL Server, such as load

The steps are as follows: Start with  understanding the process followed by the org. / company  for which you’re thinking of creating a Datawarehouse. Decide whether you need just a Database or a Data Federation or a complete Datawarehouse. Create a list of questions that you want to answer for the business  (that’ll help the business analyse data better & make better decisions using the data) through the datawarehouse. Find out the Data Source Points  & the kind of systems that the data resides in (For example, some data might be in files whereas some might be in Websites like twitter / facebook or databases such as Oracle / SQL Server / MySQL). Build a  Requirement Specification Document  & get it approved / reviewed by the Business Owners. Perform Data Modelling  to create a set of tables that you’d need in the Datawarehouse / Database. Also define the kind of dimensions (Slowly Changing, Degenerated, Conformed, Static, etc) & facts (Early Arriving) in case