Here is my take on what you are seeing with the warning in the execution plan for the case sensitive query. You are casting data from a case insensitive...

Lynn Pettis (5/19/2015)

---

SQLRNNR (5/19/2015)

---

Lynn Pettis (5/19/2015)

---

"Really? You can't help me based solely on the brief description and current output of my query?"

Why are people so reluctant to help us help...

ramana3327 (5/19/2015)

---

so either rebuild index or reorg index will use the transactional log and increase the physical log usage. We can't get that initial physical log size until we shrink...

SQLRNNR (5/19/2015)

---

Sorry, my...

What is the structure of the table? How do I cut/paste/insert...

One other question, what version of SQL Server are you running?

"Really? You can't help me based solely on the brief description and current output of my query?"

Why are people so reluctant to help us help them?

eirk tsomik (5/19/2015)

---

The whole Idea is. One session get cancelled i need to know if there are any contiguous sessions that associated with this sessions. The link is done on...

eirk tsomik (5/19/2015)

---

I have posted a sample data. The only thing I can not figure out how does the first record get in there.Because is not contiguous with any other...

eirk tsomik (5/19/2015)

---

I need to get a Contiguous time slots for the cancelled session.

If the session get cancelled I need to get all contiguous sessions that associated wit h the...

Run the following and post the results:

Select

t1.campo1,

t1.campo2

from

tabla1 t1

join tabla2 t2

...

DataTherapist (5/19/2015)

---

I wandered into the SQL Server Newbies area to see what kinds of questions are showing up here.

If this is 'Newbie', then I'm in trouble as a full time...

Yep, if you insert the data correctly, both queries work:

create table dbo.ADAssets

(Computername sysname)

insert into dbo.ADAssets

values

(N'AIRLBEOF3565 CNF:4e926e06-6f62-4864-aebd-6311543d'),

(N'AIRLBEOF3565');

select Computername

from dbo.ADAssets

where Computername like

'AIRLBEOF3565%';

select *

from dbo.ADAssets

where Computername in...

SQLRNNR (5/18/2015)

---

So, thinking about that thread that Lynn finally helped resolve, I think some pain could have been saved.

Looking at an earlier post by the OP, enough info was provided...

ramana3327 (5/18/2015)

---

So i.e. in my case the backups are not marking the VLF to reuse.

What could be the reason? Is this could be a bug?

Is rebuild Indexes also requires the...