Hi,

You can query sys.dm_exec_query_stats. There is much info about *_elapsed_time, *_logical_reads, *_logical_writes and etc.

Regards,

IgorMi

Having one physical drive D:\ on your notebook and having four...

GilaMonster (5/20/2013)

---

IgorMi (5/20/2013)

---

I have a database with a single file which size is 288GB.

I'm dropping the indexes and the data is only 90GB. I added three more files and...

This is so straightforward.

Maybe your Field2 has some invisible characters. Could you post the error message?

Regards

IgorMi

There is always solution for a particular case. But what about cases without any commas?

Here is one proposal:

declare @amt varchar(20)

set @amt = '10,000,000.00'

--desired is 10-000000.00

set @amt = substring(replace(@amt,',','-'),1,charindex('-',replace(@amt,',','-'),1))+substring(replace(@amt,',',''),charindex('-',replace(@amt,',','-'),1),len(replace(@amt,',',''))-(charindex(replace(@amt,',','-'),'-',1)))

print @amt

IgorMi

tacy.highland (5/17/2013)

---

Does the syntax look about right?

I'm getting an error:

Conversion failed when converting the varchar value 'UPDATE #Summary

SET [07:30] = 0

, [07:45] = 0

WHERE route = ['...

Nice!

crussell-931424 (5/16/2013)

---

I couldn't find much out about it either and don't quite understand how the index data is really stored. The part about the table can't be updated. Do they...

mtassin (5/16/2013)

---

Raghavendra Mudugal (5/16/2013)

---

Good one, IgorMi, thank you for the posting.

COLUMNSTORE index is very new to me and didn't had a clue on what it does, so have to take...

Hugo Kornelis (5/16/2013)

---

Raghavendra Mudugal (5/16/2013)

---

From BOL - "A table with a columnstore index cannot be updated" - seems likes the table will become as a look up table or possibly...

Grant Fritchey (5/14/2013)

---

Tempdb growth has to be because of tempdb use. There's nothing in the OS that's going to affect tempdb. It's not just temp tables. It's also any sort...

Good one.

Thanks!

IgorMi

Hi

Indexed views can improve performance significantly if you have queries that combine large volumes of data with aggregates. It should not be created against tables where lot of modifications or...

Good question!

Thanks

Hi,

What does its execution plan say? Are there any missing indexes? How big are the tables? Check the statistics on them.

You can replace the IN with EXISTS and NOT EXISTS.

Regards

IgorMi