I haven't used NetApp's solution specifically (EMC have tried to sell us their equivalent) but you need to be clear that you're not comparing like for like.

NetApp's solution is heavily...

Remember native backup compression is only included in SQL Server 2008 Enterprise Edition, so if you have Standard Edition you're out of luck anyway.

2008 R2 will also include backup compression...

Connecting to two different servers in management studio does not create a link between them, your client is simply establishing a connection to each independently.

You can only use a 4...

The best solution depends on how much data you need to transfer and the frequency with which you need to do so, as well as the bandwidth between the two...

See the below:

http://msdn.microsoft.com/en-us/library/aa366796(v=VS.85).aspx

You're not imagining it, there isn't one.

Not entirely sure of the rationale, but I guess there's an argument that they had to stop somewhere and just picked the most commonly...

No offence you your DBA, but they don't know what they're talking about if they think replacing JOIN with INNER JOIN will affect the statement in any way.

If you post...

I've never thought of using it before, but it's a good idea.

e.g. something like this would return all the cached plans I guess:

SELECT query_plan, text FROM sys.dm_exec_cached_plans

INNER JOIN sys.dm_exec_query_stats ON...

No worries 😀

I'm still kind of interested in why it would return NULL in one of those examples and blank in...

Does potentially sound like some sort of bug. What's the server collation on this server?

If you change the code to the below

select SUBSTRING(N'??????????',40,1)

select SUBSTRING(N'??????????',20,1)

Does it have a different effect?

Wondering if...

As Paul said, this is all a bit academic as there's a better answer to the orginal query, but if the database was detached, which is an operation that can...

Underscores are a special case and represent any single char within an expression.

e.g:

where column_name like '_ones'

Would return Bones, Jones etc. etc.

You need to specify that you're specifically looking for underscores...

Yes, absolutely. It could return any depth where the attribute_id is NULL.

TOP simply returns the first N rows that are returned by the query, it has no inherent order.

The order...

It's not excluding anything. It's telling you the difference in days between the two dates.

Despite the fact that if you counted from the start date to the end date you'd...

Jeffrey Williams-493691 (3/29/2010)

Do not do this - unless you...