KGJ-Dev (2/4/2015)

---

Hey Guys,

I am working in sqlserver 2008 R2

I have an interesting question. My question is does index Reorganize and rebuild everyday increases the DB performance? Which is good weekly...

david.dartnell (2/4/2015)

---

Hi Everyone,

I have a general question concerning joins. Below is a table scenario that I would like advice on -

SELECT *

FROM TABLE_A T0

INNER JOIN TABLE_B T1 ON T1.[Some_Column] =...

patrickmcginnis59 10839 (2/4/2015)

---

dwain.c (2/4/2015)

---

Sounds like a problem I had recently and the same solution too.

SQL Query invoked by Crystal Reports v9.2 Performance Issue

I'm a great believer in going with what...

Isn't this what PARSENAME is for?

WITH SampleData AS

(

SELECT Fullname = 'Pawar, Ramesh S.' UNION ALL SELECT 'Damon, Matt'

)

SELECT *

,LastName ...

Nasty CROSS JOIN that.

Perhaps one of these instead?

CREATE TABLE #NumVals (ID INT, MatrixCat VARCHAR(100), MatrixVal VARCHAR(100));

INSERT INTO #NumVals (ID, MatrixCat, MatrixVal) VALUES

(1, '# Ready To...

Lynn Pettis (2/4/2015)

---

gatorfe (2/4/2015)

---

We are running sql 2008 R2. We have the JE_DATE field set up as an int. We are trying to subtract 30 days from this...

Quite interesting.

This illustrates the problem.

CREATE VIEW dbo.Test

WITH SCHEMABINDING

AS

SELECT

RecordLastChangedDateKey=20150204,

x=CAST('20150204' AS DATE) ;

GO

CREATE UNIQUE CLUSTERED INDEX IDX_t1 ON dbo.Test (RecordLastChangedDateKey, x);

GO

SELECT *

FROM dbo.Test;

GO

DROP VIEW dbo.Test;

Perhaps this solves it?

CREATE VIEW dbo.Test

WITH SCHEMABINDING

AS

SELECT...

Sounds like a problem I had recently and the same solution too.

SQL Query invoked by Crystal Reports v9.2 Performance Issue

I'm a great believer in going with what works, without trying...

Jeff Moden (2/4/2015)

---

Sean Lange (2/4/2015)

---

Sioban Krzywicki (2/4/2015)

---

Sean Lange (2/4/2015)

---

Sioban Krzywicki (2/4/2015)

---

Grant Fritchey (2/4/2015)

---

Eirikur Eiriksson (2/4/2015)

---

Sioban Krzywicki (2/4/2015)

---

Grant Fritchey (2/4/2015)

---

Brandie Tarvin (2/4/2015)

---

Anyone know anything about this Grant guy? Does he...

If this is Romley's division (I'm sorry but I did not recognize it as such, which of course doesn't mean that it is not), Peter Larsson proposes a faster method...

Never say never!

One day you'll want to add "4 - prior customer" for a contact that used to be a customer but is no longer paying for your services.

I'd go...

As it turns out, I have a pretty efficient Calendar Table-generating function that makes short work of this:

create table #temp(account int, loc varchar(10), startdate datetime, enddate datetime);

insert into #temp select...

Actually this is more like what I was thinking about.

create table #test_table (LP varchar(100), Original varchar (250), New varchar (250));

insert into #test_table

select '/page1' as LP, 'the quick brown fox jumped...

Now this has gotta be a first! Someone honored to be flamed by he who should not be named.

http://www.sqlservercentral.com/Forums/FindPost1656896.aspx

And the flaming solution marked as "worked for the OP!"

sqldriver (2/2/2015)

---

Ah, yeah, it's not much more rows than this. I guess the point of the secondary relationships is 'route choosing' of sorts. Like, if you start with BarX, these...