Take a look at the undocumented procedure sp_MSforeachdb. A quick internet search will provide you with plenty of examples of how to use it and the pitfalls that come with...

Yes you can do this quite easily.

select col1, col2

into #temp

from dbo.fn_MyFunction(1)

select * from #temp

I would suggest that you look at your function more closely. You have declared your...

forceman29 (12/13/2012)

---

I'm running server 2008 R2. How do you do a database restore with just structure and no Data?

I've looked online and either I haven't looked in the right...

The image datatype exists for 2005. Use the import data wizard on the 2005 instance and you should be fine. Of course you said you are using the image datatype....

dsorensen 97289 (12/13/2012)

---

I am using SSMS 2008 version 10.50.1617.0 connected to a 2008 R2 SQL server. For some reason, when I run queries that are not necessarily affecting rows,...

Michael T2 (12/13/2012)

---

using that, i still have the table scans. if i only use

and (txSubtype > 'BACKORDER'

or txSubtype < 'BACKORDER'

then the scans go away.Strange.

I am going to read up...

Michael T2 (12/13/2012)

---

if i take out

AND coalesce(txSubtype,'') <> 'BACKORDER'

no records are returned. thats why i am using the coalesce. Most of the records i need have a null...

You do realize that this query will not produce consistent results?

select

@indateto = dateto

,@inseason = seasonid

from

tblSeasonDates

where

datefrom<@datefrom

and

dateto>@dateto

and

seasonid in (select seasonid from tblSeason where groupid=@groupid)

If there is more than 1 row returned from...

Why do you have NOLOCK and READUNCOMMITTED? You are using two query hints that do the same thing. Do you really need/want to use this hint? Are you aware of...

You can still...

I still say that if you are only looking for dbo that it seems unnecessary. If you have only one schema everything will be created there anyway. Unless you are...

Actually NOLOCK is far worse than simply dirty reads....

Nice question Lokesh. Keep them coming.

Can you post the actual table and index definitions? Both of those index scans look like your stats might be stale. They both have an estimated row count of about...

Using your description in your last post here is some code that will do exactly what you said you want to happen.

create table X

(

Prog int

)

insert X

select 1 union all

select 2...