jayoub (8/13/2015)

---

I am trying to STIG my Instance and databases and wonder if you can help. I need help figuring out how to do the following:

At the DB level:

STIG...

Have you verified that there are no other records that would otherwise qualify to pass through this query, where the divisor ends up being 0 ? Also, check...

Glad I could help. Let us know how it works out.

Has anyone considered something like this?

DECLARE @test-2 AS TABLE (

Column1 int,

Column2 int

);

INSERT INTO @test-2 (Column1, Column2)

VALUES (978555, 500),

(978555, 502),

(978555, 480),

(978555, 490),

(978324, 1111),

(978324, 1102),

(978311, 122),

(978311, 120),

(978994, 804),

(978320, 359);

WITH RAW_DATA AS (

SELECT...

Polymorphist (8/13/2015)

---

Okay, so I kind of answered my own question here -

CASE WHEN LEN(Call_Transaction_ID) > 1 THEN call_transaction_ID ELSE -1 END

When I did a LEN(Call_Transaction_ID) on the field I...

Now I'm thinking that I had to go through this twice to fully understand. ...

Bruceo (8/13/2015)

---

Hi Steve,

Sorry, my explanation on this might not have been adequate. Let me try to explain again.

From the table BenID and BenIDNew are the movement between Beneficiaries.

What I need...

At first, my modified version of your code used a table variable, but the IO STATS on it were awful, so I went back to a temp table and re-posted...

Bruceo (8/13/2015)

---

Hi All,

I have a Transactional table containing IDs that relate to each other. The table highlights the transactions that move one ID to another, by storing an ID and...

Xedni (8/12/2015)

---

Thanks, Steve.

So let me ask a more general question, assuming many companies don't run solely out of a single data center, what do people REALISTICALLY do to keep things...

staticlie (8/12/2015)

---

Hello, I am working on moving information from one of our databases into a newer one the company has recently setup. I am working in MS SQL...

SQLRNNR (8/12/2015)

---

Grant Fritchey (8/12/2015)

---

Following on ignorance, you also get laziness, misplaced priorities, complaisance (who would hack us?), even active resistance to change (although, link that back up to ignorance again)...

Xedni (8/11/2015)

---

Hi SSC,

The project I work on has a sort of weird setup. We run 3 data centers, hot/hot/hot and traffic is load balanced to each data center. The way...

I think I might understand the kind of alternative you might be looking for, but it's very much a guess given the lack of details. How about something...

If two columns are used to uniquely ID the record, why are you appearing to join on the 7 columns that are NOT used to do that? Or...