Thanks for the Article.

I voted it with 5 stars.

But there's only a hole:

Your query doesn't consider the order on columns.

Example:

create index idx_MyTab on MyTab(col1,col2)

and

create index idx_MyTab_1 on MyTab(col1 DESC,col2)

So, in...

Thanks!

declare @t varchar(10) = 'FALSE'

,@b bit

SET @b-2 = CAST(@t as bit)

select @b-2

WHERE @b-2 = 'FALSE'

http://msdn.microsoft.com/en-us/library/ms174378%28v=sql.110%29.aspx

Raghavendra Mudugal (5/30/2014)

---

Good one, thank you for the post.

Agreed F6 and SHIFT+F6 - both works. But they are not the same.

F6 in SSMS is "move to the next pane"...

Also SHIFT+F6. These hot keys are windows standard.

Unbelievable!!!

Someone get it wrong!

😀

TomThomson (5/8/2014)

---

naas2005 (5/8/2014)

---

Just a note on the tinyint - to store negatives in one byte the rightmost bit of the byte (111111 0) would need to be used to sign...

stephen.long 56048 (5/5/2014)

---

The list shown here includes bit in the list of "exact numeric types".

http://msdn.microsoft.com/en-us/library/ms187752.aspx (Data Types (Transact-SQL))

The definition of bit, shown here, calls it "An integer data...

In SSMS 2008 r2, results could be copied only in grid mode or if the amount of the text is less than 2MB. If text is more than 2MB you...

When results come out in text, you can search for a string (ctrl+f), instead, in grid mode you can not search in the results.

Good!

kupy (4/7/2014)

---

Carlo Romagnano (4/7/2014)

---

happycat59 (4/7/2014)

---

SET NOEXEC might find syntax errors but it doesn't find all errors. I copied a piece of code that included a "RANK... PARTITION BY [invalid...

happycat59 (4/7/2014)

---

SET NOEXEC might find syntax errors but it doesn't find all errors. I copied a piece of code that included a "RANK... PARTITION BY [invalid column]" -...

free_mascot (4/2/2014)

---

I have executed in SQL 2012 and got...

I do not like question too long. I have just few minute to answer.

A lot of useless words and none of the main one.