That's because your Excel file doesn't have...

*sigh*

ChrisM@Work (3/18/2015)

---

appdev13 (3/18/2015)

---

I am having a table with over 120 million rows. I am executing a count query and it is taking about 4 mins to execute. Every 1 second...

The clustered index cannot be used for a seek because of the the column [sys_service_id] (which is not included in your SQL statement).

To get a seek, you can either reverse...

The ACME coffee machine is nice touch 🙂

Lowell (3/18/2015)

---

...

there a nice softball of a suggested missing index right there.....i bet you could hit that one out of the park.

also, why not count(*)? it would be faster, i...

+1

A lot of confusion could have been avoided.

+1 If you want extra functionality in SSMS, you need to create an add-in, or install a 3rd party add-in that achieves your requirement.

A dummy value. Something that is definately not equal to 1.

rexyrexin (3/18/2015)

---

Thats why you have OR in between to...

> Then I tried populating the tables then establishing my primary keys using script to set their values to ' NOT NULL' which results in my data being dumped!

Which...

select * from mytable

where class='something'

and (xyz is null OR xyz = 1);

You really need to give more information. We cannot see your screen.

Any indexes on the table?

-- edit: sorry, I was too fast, you mentioned this already in your question.

What does the query plan say? Is an index seek used?

mauliks1990 (3/18/2015)

---

how to convert float to timestamp in single select query

for exp. i have float as 1.251152515236 ,

i want to convert this to datetime and from datetime to timestamp......

I would assume that SSIS only takes read locks on the table, but I'm not sure on what level.

How the database handles those locks is dependant on the kind of...