happy55 (12/27/2013)

---

thanks for the reply.I am doing the same thing but still i am not geting all rows present in Table a .

I am geting only those for which the...

happy55 (12/26/2013)

---

I have a

Table A

id

description

Table B

uniqueId

name

id

where id in b is same as id in A

I want to count all uniqueId in B for each id in A

I...

vladisaev@hotmail.com (12/27/2013)

---

thank you for your feedback/insight.

So when we say that Covered Index is created for one particular SQL statement it is a relative term, right? We really mean that...

vladisaev@hotmail.com (12/26/2013)

---

IF I have a SP in which the following actions occur:

1 - Declare @Table table (.......)

2 - INSERT INTO@Table SELECT F1, F2, F3, ... From ..Joins... ...

vladisaev@hotmail.com (12/26/2013)

---

If I create a covered index, analyzing a specific query

like

Select F3, F4, F5 from Table1 Where F1=@F1 and F2=@F2

Index created as follows:

Create index IXc_Table1__F1F2

on...

sneilson (12/24/2013)

---

wolfkillj (12/23/2013)

---

sneilson (12/23/2013)

---

The actual stored procedure is quite complex but essentially is picking up a money field multiplying by a decimal (23,10) and then calculating a percentage by multiplying...

sneilson (12/23/2013)

---

The actual stored procedure is quite complex but essentially is picking up a money field multiplying by a decimal (23,10) and then calculating a percentage by multiplying by an...

A SAN, a LAN a la NASA.

New blog post for your weekend enjoyment:

Things That Make You Go "D'oh!" - Part 1: My Arithmetic is Overflowing???

Like Bartles & Jaymes, we thank you for your support.

Andrew Notarian (12/20/2013)

---

I think we phone screened that person for a job once. Every question resulted in awkward silence, then some non-related babble, followed by an extremely well stated...

CK2 (12/19/2013)

---

I think it's the column alias causing the error.

Try it like this:

Select

SUM(Case when CTE1.Status = 'No' Then 1

when CTE1.Agent_Status= 'Aged' Then 1

when CTE1.Platform = Production Then 1

When CTE1.Critical...

So you have a date value for the Dec. 18 of the...

sneilson (12/19/2013)

---

I am at a loss - but also a bit of a novice. We have a SQL 2005 SP2 (A) with a linked server set up to a...

pjbaratelli (12/18/2013)

---

IndexValue - decimal(18,6)

GeometricLinking is...

ScottPletcher (12/19/2013)

---

Jeff Moden (12/18/2013)

---

ScottPletcher (12/18/2013)

---

If your lookups will most often be by column2, you need to cluster the table on column2, or an encoded version of it, rather than having...