Think of a telephone directory. If you want Mr R Brown, you can go straight to the right entry, because the telephone directory is set up that way. That's a...

The Dixie Flatline (7/1/2011)

---

# 1. In your example, the optimizer uses the nonclustered index because it is a "covering" index containing all the columns needed to satisfy your...

Is there a compatibility issue for nvarchar field between sql server 2008 r2 64 bit and sql server 2000?

The replication is failing saying An error occurred during running the batc...

After a long time and lots of Tuna,watermelon,liquor,asterix and obelix discussions:

Sorry for not being able to put up the question properly.

what i wanted to ask was :

which one is better...

SK,

I will tell u the solution that i have found for my issue , check if its useful for u .

i have configured the destination so that a new table...

Thanks a ton guys for your replies.Ultimately used Columns_Updated().

Facing a the same issue almost .

BackGround:A job runs every month to load an excel file to SQL Server.The Excel file differs Month to Month and hence cannot be imported...

how to determine the bit value thats going to have & to the columns_updated() functon?

The formula 2^(column ordinal-1) rsults to a huge value when summed for 80 cols

try this as well

SELECT

a.request_id,

a.req_type,

a.status,

b.event_type,

b.person_id_from,

a.check_for_billing,

a.billing_allowed,

c.text_line_code

FROM

Request a left outer join request_event b on a.request_id = b.request_id left outer join request_text c on a.request_id = c.request_id and c.text_line_code <> 'RAQA'

WHERE

a.req_type in ('auto', 'tac')

and...

Thanks for the reply. So what i understand is , if i alter the table such that the composite primary key is defined as "LocationID,ProductID" instead of "ProductID,LocationID" as it...

hmm the problem is still there. When i ran it for a small set of data , it worked, but when i increased the amount of data its again doing...

ok found the answer. I had kept the Scalar value checkbox checked and so was not able to get the actual values. Once i uncehcked that , i was able...

The limitation of the process discussed here is that we need to know the exact list of valid parameters and need them to have it in a table. Though this...

The small review by Tim was excellent.

I am just starting with SQL Azure and was going through diff documents available under MS Windows Azure site.

As far as i understand...

In simpel words it is SQL Server on Cloud.Your database will be on the Cloud servers and not at your data center thus reducing the Infrastructure/management/administration/Memory/etc etc issues and costs....