Viewing 15 posts - 886 through 900 (of 11,678 total)
e_dorham (3/18/2015)
If I set the primary before I import data I get an error message and the table is not populated with the data.
That's because your Excel file doesn't have...
March 18, 2015 at 3:14 pm
GilaMonster (3/18/2015)
(look at the query the execution plan shows, it's different from the one initially posted)
*sigh*
March 18, 2015 at 8:19 am
ChrisM@Work (3/18/2015)
appdev13 (3/18/2015)
March 18, 2015 at 7:28 am
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...
March 18, 2015 at 7:11 am
The ACME coffee machine is nice touch 🙂
March 18, 2015 at 7:05 am
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...
March 18, 2015 at 6:25 am
twin.devil (3/18/2015)
a sample set and desired output will help to identify your actual scenario.
+1
A lot of confusion could have been avoided.
March 18, 2015 at 4:48 am
+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.
March 18, 2015 at 4:42 am
rexyrexin (3/18/2015)
select * from mytablewhere class='something'
and ISNULL(xyz, 99) = 1);
What is 99?
A dummy value. Something that is definately not equal to 1.
rexyrexin (3/18/2015)
March 18, 2015 at 4:30 am
> 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...
March 18, 2015 at 4:04 am
select * from mytable
where class='something'
and (xyz is null OR xyz = 1);
March 18, 2015 at 3:58 am
appdev13 (3/18/2015)
clustered index is getting used as per the query plan.
You really need to give more information. We cannot see your screen.
March 18, 2015 at 3:05 am
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?
March 18, 2015 at 3:00 am
mauliks1990 (3/18/2015)
for exp. i have float as 1.251152515236 ,
i want to convert this to datetime and from datetime to timestamp......
March 18, 2015 at 2:14 am
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...
March 18, 2015 at 1:58 am
Viewing 15 posts - 886 through 900 (of 11,678 total)