Quick note, the SQL Server Data Tools is the replacement for BIDS and provided as a separate downlod.

😎

Very good points there Steve and the in a nutshell the reason why I tell the DBAs to register at SQL Server Central.

😎

snoqualmiewa (5/16/2015)

---

Hi,

The insert statement in page 294 fails (SQL Server 2014 Integration Services text by Brian Knight). Any Ideas what data should be entered for the PACKAGE ID? Thanks

INSERT INTO...

Further on Steve's reply, probably the best gain would be in spreading the tempdb data files.

😎

Jeff Moden (5/15/2015)

---

Oddly enough, I've seen the "query builder" generate such code a whole lot in my early days and it worked just fine. There are places where it...

Scott Coleman (5/15/2015)

---

If an OPENQUERY statement could make use of the @EndDate parameter, he wouldn't need dynamic SQL in the first place.

I have a lot of code that references our...

born2achieve (5/14/2015)

---

Hi Eirik,

I am into trouble now about some street names having names city name and the current logic removed the the street name as well

ex:

address = '555 Manhatten...

Sapen (5/14/2015)

---

Hello,

I am using sql2012 se and we want to use couchbase to store some data as documents. So the database will be Hybrid(partly SQLServer and Partly couchbase). However the...

Gregg Dave (5/15/2015)

---

Eirikur Eiriksson (5/15/2015)

---

Quick question, why would you...

Quick question, why would you want to do that?

😎

vipin_jha123 (5/15/2015)

---

Hi ,

I want to calculate the Hash value of below columns.

I have table having below columns

[Equipment_Id] + [EquipmentCompCode] + [EquipmentUnitNo] + [EquipmentSerialNo] + [EquipmentPlateNo] + [EquipmentExpireDate]+ [EquipmentState] + [EquipmentAxles]...

stephanigracie (5/14/2015)

---

Hi All,

Please help me, I have a questions regarding SSIS Config file.

Last month I have bought SQL server hosting at asphostportal.com. Before that I have a simple...

Sapen (5/14/2015)

---

Hello,

I am using sql2012 se and we want to use couchbase to store some data as documents. So the database will be Hybrid(partly SQLServer and Partly couchbase). However the...

You are missing the data type in the first cast in the where clause!

😎

My question...

Gregg Dave (5/14/2015)

---

which way is faster .

Inserting data into a table having clustered Index or Inserting data into a table then create clustered index.

Insertion happens from a different table...