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...

i1888 (5/14/2015)

---

Hello,

We have a client in another country, I have asked them to send me the full backup in a usb, and upload ongoing log files via SFTP, something weird...

Looks like a healthy piece of kit you got there, first question is how these numbers compare to what it says on the box, for a mid range SAN this...

orman.ionut (5/14/2015)

---

Hi guys ,

Is it possible to determine the data flow within a database? e.g. I start by adding/inserting a record in MainTable1, then through a trigger SubTable1, SubTable2...

Just to pile on a bit, use the desired collation to get the desired sort order

😎

Collation example with Lowell's data sample:

use tempdb;

go

;WITH MyCTE([ColumnName])

AS

(

SELECT N'000000000000001' UNION ALL

SELECT N'000000000000005' UNION ALL

SELECT N'000000000000006'...

SQL Guy's suggestion is good, only concern would be how the DBAs are going to react with all the verbosity unless you filter the result set.

😎

Wishes