Marv2011 (4/3/2015)

---

I have a table that has a date of birth column. Unfortunately its a varchar data type. I would like to convert this column in a view to a...

Flush

jasona.work (4/3/2015)

---

Looks like that site might be showing an older version of the STIG then.

The date on the one you linked to is 6-23-2014, the date on the one I...

sqlnaive (4/3/2015)

---

Hi Eirikur, Thanks but this was a question with just an example. Actually it is a generic one. String could be anything and not just "abcd_e_fgh".

Though i've just...

Koen Verbeeck (4/3/2015)

---

Eirikur Eiriksson (4/3/2015)

---

sqlmaverick (4/2/2015)

---

Hi all,

I have to eliminate comma in last field of a file in flat file connection manager. when I check the source file I didn't...

Gender

Slightly different approach

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

DECLARE @Expression VARCHAR(8000) = 'abcd_e_fgh';

DECLARE @SearchString VARCHAR(10) ...

Sioban Krzywicki (4/3/2015)

---

Koen Verbeeck (4/3/2015)

---

Eirikur Eiriksson (4/3/2015)

---

Are you grumpy because you are working on the Good Friday or was it the last night "preparation"...

Depending on the usage, distribution and cardinality, there are few options to speed this up.

😎

One would be adding a calculated column and then index the column, this has little...

Koen Verbeeck (4/3/2015)

---

Eirikur Eiriksson (4/3/2015)

---

Are you grumpy because you are working on the Good Friday or was it the last night "preparation" for it...

Are you grumpy because you are working on the Good Friday or was it the last night "preparation" for it that make you grumpy?...

sqlmaverick (4/2/2015)

---

Hi all,

I have to eliminate comma in last field of a file in flat file connection manager. when I check the source file I didn't see any commas but...

I use this Microsoft SQL Server 2012 Database Security Technical Implementation Guide[/url]

😎

Apart from the...

jasona.work (4/3/2015)

---

I started having this issue yesterday, after applying a change to bring my server(s) in compliance with the DISA STIGs. One of the requirements of the STIG is...

For starters can you post the DDL (create table) for the tables and some consumable sample data in the form of an insert statement? This will increase your chances of...