Also - keep in mind that this may not be running under your credentials. Depending on circumstances or version, you may need to check that the following user accounts...

The question isn't so much whether you CAN make it use the index, it's more is it SMART to force it to use the index. The reason it's not...

I'm thinkingh they're talking about the new SQL 2008 Change Data Capture functionality. I'm very sketchy on how it works in SS2008, so your best bet is to pop...

I use it a fair amount for two-step XML extractions (I have XML data being stored in a...

to finish Paul's thought: rebuild basically doesn't do much in the way of rebuilding if the indexes are under a certain size (since the entire index will be in memory,...

As far as I know - this has ALWAYS been true. Just doing a simple search in BOL - I can find the reference in 2000, 2005 and 2008...

According to SQL-92 - two NULLs cannot be deemed distinct from each other (which is why you would see a *single* NULL in the group value for an Aggregation query...

Michael Coles wrote an article about this. Enjoy -

http://www.sqlservercentral.com/articles/Advanced+Querying/gotchasqlaggregatefunctionsandnull/1947/%5B/url%5D

karthikeyan-444867 (9/30/2009)

---

I am just wondering becuase select 1+2+3+null gives 'NULL'. So the optimizer has some inteligence here.

But the same optimizer act like a fool when select sum(columnname) executed.

so...

As far as I know - with an external file coming from a web site (i.e. somewhere you cannot get to via a drive mapping, etc....), you would need some...

... to do what esactly? ...

It's a bit of a tricky question. First let's start by saying that yes - it will only update those rows that match the WHERE clause if you give...

Per BOL, COMMIT Transaction does the following:

Marks the end of a successful implicit or explicit transaction. If @@TRANCOUNT is 1, COMMIT TRANSACTION makes all data modifications performed since the start...

Are you sure that the "destination" version of Table A actually has an identifier column? Because you're correct - you cannot insert into the identity column without setting the...

Two thoughts:

- how did you come to pick the clustered key combination? Something resulting in a lot of page splits might not end up being the...