Viewing 15 posts - 6,961 through 6,975 (of 7,636 total)
The EXEC('string') commands run in their own, individual, separate batches.
So these two commands:
exec ('use '+dbname)
exec(@parm)
Have no functional impact on each other. (also, I don't think that an...
May 6, 2008 at 2:17 pm
Some other things to try: grant (explicit) reader access to Master & TempDB.
Does this happen with the other SHOWPLAN settings or just XML?
Make sure that they have rights to View...
May 6, 2008 at 2:05 pm
Frankly, guostong, with that table design, I would probably just go with your original query. Unless you change the table, you probably cannot get anything significantly faster anyway.
May 6, 2008 at 1:48 pm
You will get a better response in one of the SQL 7,2000 forums on this site.
May 6, 2008 at 1:38 pm
helloanam (5/6/2008)
i think this is what you want
select b.*
from sys.objects a inner join sys.columns b on a.object_id = b.object_id
where a.[name] = 'test1'
replace 'test1' with the table name
No, that returns...
May 6, 2008 at 12:25 am
alanm (5/5/2008)
I have an SQL database, and I was wandering how to export data from the tables to an XML file – do you know how to do this?
Look at...
May 5, 2008 at 11:20 pm
Hmmm, slight problem here. You describe a problem converting SqM to SqHA:
sidpchandra (5/5/2008)
May 5, 2008 at 8:28 pm
I believe that it is an Extended Property.
May 5, 2008 at 8:12 pm
Well, that is because the Where clause of your first query is not the same as the other two. Your first query:
...
WHERE 'email' LIKE '%'
versus the other two:
...
WHERE emailwork...
May 5, 2008 at 8:11 pm
Also, turn CPU & IO statistics on in Query analyzer and let us no what the comparative numbers are, especially logical & physical IO.
May 5, 2008 at 8:06 pm
What are the differences in your CPU time, Disk Idle %, and hard & soft pages faults?
May 5, 2008 at 8:04 pm
Yes, use one of the many techniques that we posted here for you.
May 5, 2008 at 7:34 pm
Viewing 15 posts - 6,961 through 6,975 (of 7,636 total)