What happens if while the pages are deallocated , another task / process / txn ( or something ) allocates that space for other purposes , and I run the...

free_mascot (3/11/2014)

---

Yes, initially I have drafted the question straight forward but it looks very simple. Deliberately make it complicated by tricky language to make challenging.

Usually everyone knows correct answer...

I use comments to test changes to parameterised stored procedures without having to create or alter the sproc first.

/**/

CREATE PROC Test @param1 INT, @param2 VARCHAR(20) AS

--*/DECLARE @param1 INT/*

--*/DECLARE @param2 VARCHAR(20)/*

--*/

SELECT...

When I logged in it gave me an error, but refreshing the page let me in.

Other than that it seems to work well on my Dell Streak. 🙂