GSquared already mentioned it in a previous post:

GSquared (2/24/2011)

---

What you're hitting here is the age-old conflict on how best to architect data warehouses. One is "star/snowflake schema", one is...

SQLkiwi (2/24/2011)

---

e90fleet (2/24/2011)

---

Is there a way to bulk insert multiple files from a shared folder into a table without using xp_cmdshell? Using SSIS and turning xp_cmdshell on is not...

I would like to take a shot at this one...can you please provide the DDL for your tables and some DML to build some test data?

Double post...please direct all replies here:

http://www.sqlservercentral.com/Forums/Topic1069402-392-1.aspx

sp_help wlll tell you all referenced as well as referencing keys. You want to look at the last two result sets:

USE AdventureWorks

GO

EXEC sys.sp_help @objname = 'HumanResources.EmployeeDepartmentHistory'

If you are interested you...

harmand (2/25/2011)

---

THANK YOU

Another problem. I have catalog table with a description field. If the description has a comma in it the field in the flat file is in double...

Lowell's example uses xp_cmdshell to find a list of files to BULK INSERT from specific directories. If the files you'll be BULK INSERTing will never change, or can be sent...

As with most things it will depend on a lot of factors...more than we can discuss in this forum. However as an initial direction for supporting reporting functions denormalizing the...

BOL: http://msdn.microsoft.com/en-us/library/ms190998.aspx

You'll need to supply a format file. This post may help:

http://www.sqlservercentral.com/Forums/FindPost99982.aspx

Possible...

I would designate the values you have for Products (Shirt), Colors (Green, Blue, etc.) and Sizes (S, M, L, etc.) as "natural keys". Surrogate keys (IDENTITY) are my preferred way...

namrata.dhanawade-1143388 (2/23/2011)

---

Requirement:

There are 100 tables each with different number and type of columns and obviously different rows.

And then there is a condition to check if some 5 columns...

Your OP says you're trying to alter columns from INT to BIGINT but your script is altering columns to VARBINARY(MAX). What exactly are you trying to do?

In any case you'll...

Here is why using the sp_ prefix for your proc names is a bad idea:

http://blogs.msdn.com/b/jenss/archive/2009/04/28/a-long-but-not-missed-friend-revisited-prefixing-stored-procedures-with-sp.aspx