PHYData DBA (4/22/2015)

---

Only simple comparisons work.

NOT + <any...

Realy don`t understand why can`t we use "Not In" for a filtered index while we can use "In" operator?! :w00t:

Very nice question, had to test it before answering 😉

And the shortcut 4 exec sp_help dsa is highlight the table and press Alt + F1

+ 1, I am not using COALESCE much lately.

Interesting question, thanx.

[Using XML in Computed Columns], hmmm, that`s somthin new. Thanx

This is 4 the Computed Column question, don`t know how it came here :hehe::cool:

Ok good to know that, thanx.

From http://www.sqlserverspecialists.com/2013/02/log-stream-compression-sql-server-2008.html:

[With SQL Server 2008 (I think the same applies to 2012), the log stream is compressed by default. To measure the impact of log compression, we used the trace...

:-D:-D

peter.row (4/10/2015)

---

The script in the answer fails because of the following:

select @a, @b-2, @C

As @C is not declared (nor is it used...

True, this is possible but not practical @ all, who will...

+1, this should have been mentioned in the question.

I don`t remember loading a flat file into a SQL table since long time, so it`s good to know a new stuff 🙂

Now it`s even 11 years old thread, but amazingly still very useful to fix the current issues, seems that MS will never ran out...

Just want 2 thank u cause that...