Thats great question. Thanks.

We are not able to see the execution plan of encrypted stored procedure, if that is the case then there is the need of encryption keyword 🙂

If we use...

Really Nice question.

GO [count] is nice command to execute the batch no of times. Today's QoTD (11/23/2010) is also refer GO [count] statement. 🙂

Brigadur (11/23/2010)

---

Hardy21 (11/23/2010)

---

DougieCow (11/23/2010)

---

Hardy21 (11/23/2010)

---

Try

INSERT INTO #

SELECT 'ASDF'

GO 0

GO <ZERO> --- SQL doesn't throw any complilation error but when you execute the code, status bar should display: "Query completed...

DougieCow (11/23/2010)

---

Nope,...

Try

INSERT INTO #

SELECT 'ASDF'

GO 0

GO <ZERO> --- SQL doesn't throw any complilation error but when you execute the code, status bar should display: "Query completed with errors".

Nice post 🙂

Nice command. Thanks

Good one point question.

Below query returns the required result:

select * from tempdb..sysobjects where name like '#testvm%'

Nice wording by Nakul.

I also say that rating yourself is not required or at least I am avoiding that. Due to SQL Server (or any nowadays any technology) is very...

Very nice question though I got it wrong.

I was thinking because of only 3 bit column, it should take 1 byte only same as tinyint.

Good introductory article about Indexed view.

We need to be very careful while creating indexed view due to schema dependency. Once you have a indexed view, you can not modify...

Good to know.

Carlo Romagnano (11/15/2010)

---

Execute the batch without the 'GO'

EXEC uspLogError

SELECT st.text QueryText,objtype

FROM sys.dm_exec_cached_plans

CROSS APPLY sys.dm_exec_sql_text(plan_handle) AS st

WHERE text LIKE N'%uspLogError%'

Result:

CREATE PROCEDURE [dbo].[uspLogError] ....,'Proc'

EXEC uspLogError SELECT st.text QueryText...