Vishal.Gajjar (10/27/2011)

---

Adhoc queries need to be exactly same for reuse. i.e. case-sensitivity, white spaces, etc...

Generally, When a statement is used inside a stored procedure, it's not going to change and...

:hehe: Quite right.

Strange coincidence!

I think that the misinformation comes from good advice that turned into bad advice with new SQLServer versions.

In SQL Server 2000 we did not have "plan cache", there was just...

jcrawf02 (10/26/2011)

---

what do you guys use for calendar apps? (non-iPhoney people) <--hey, that's funny, didn't even mean that...

missed a couple user group meetings I meant to get to (online), would...

Great question, Paul, and great explanation.

Looks like you tricked most of us (myself included).

WayneS (10/26/2011)

---

SQLRNNR (10/26/2011)

---

WayneS (10/26/2011)

---

Thanks Jason.

Like I said in my blog[/url], I only submitted the winning entry... SQL Server 2012 is the winner...

GilaMonster (10/26/2011)

---

BrainDonor (10/26/2011)

---

GilaMonster (10/26/2011)

---

BrainDonor (10/26/2011)

---

No no no no no - if it doesn't make the bookshelf bend then it isn't worth buying. I haven't yet moved to ebooks (unless it's...

Another possible solution:

DECLARE

@Param1 varchar(50),

@Param2 varchar(50),

@Param3 varchar(50),

@Param4 varchar(50),

@Param5 varchar(50),

@Param6 varchar(50),

@Param7 varchar(50),

@Param8 varchar(50),

@Param9 varchar(50),

@Param10 varchar(50)

SELECT

@Param1 = NULL,

@Param2 = 'Value1',

@Param3 = NULL,

@Param4 = NULL,

@Param5 = 'Value2',

@Param6 = NULL,

@Param7 = NULL,

@Param8 = NULL,

@Param9...

MysteryJimbo (10/26/2011)

---

Gianluca Sartori (10/26/2011)

---

I agree that shrinking tempdb may not be is not a good idea.

However, you could try to issue DBCC FREESYSTEMCACHE('All') before shrinking. This flushes the system cache,...

Well, something, actually.

You could use Aaron Bertrand's replacement[/url] or my humble attempt[/url].

I agree that shrinking tempdb may not be is not a good idea.

However, you could try to issue DBCC FREESYSTEMCACHE('All') before shrinking. This flushes the system cache, including internal objects...

Is that a limitation in the ASP code?

In SQLServer, under many circumnstances, views are updateable, so it would be no problem.

I've never used scaffolding and I'm not sure what to suggest. If it was my application, I would use a view to retrieve the aditional column and expose the view...

Konstantin Konstantinov (10/23/2011)

---

The main table from these is "Office". The users want to see the link to the "Office" in each table that take a part in relationships with one....