tstaker (3/22/2010)

---

This was my experience as well as a manager of DBA's interviewing new candidates. I've avoided the certifications for years because of nightmare interviews with people who were...

😀 So it was a table trigger after all! 😀

Glad the semi-colon thing helped.

Please look up the QUOTENAME function - it allows your code to cope with database names that...

EdVassie (3/23/2010)

---

Paging is done by Windows. SQL Server cannot tell Windows to page or to not page any of the SQL Server memory. The 'lock pages in memory'...

It looks as if the intention here is to disable a database trigger.

Aside from the other syntactical errors, the syntax is 'DISABLE TRIGGER {name} ON DATABASE'.

You use the word 'DATABASE'...

Aspet Golestanian Namagerdi (3/22/2010)

---

In SQL SERVER 2000, after running each SQL Statment ,I was checking @@Error variable, tomake sure that there was not any error.In SQL SERVER 2008,there is Try/Catch...

Not sure if I fully understood the requirements, but...

DECLARE @Source

TABLE (

companyname VARCHAR(10) NOT NULL,

...

Use APPLY with TOP. If you provide easily consumable test data, I will write a demonstration script.

Executing synchronously means that each sp_executesql...

It is usually more efficient to just return one data set, and return the row count in an...

Tweaked:

DECLARE @Sample

TABLE (

code CHAR(1) NOT NULL,

value INTEGER...

My experience of interviewing is that candidates with certifications lack practical knowledge. Just an observation.

Some code to illustrate my point about indexed computed columns. Note that the computation is performed on the column reference.

-- Persisting whole_date2 only works in 2008

CREATE TABLE #Test...

Attaching the text file to this post to make accessing it easier than going via rapidshare.

When you attach the graphical plan, be sure to upload it as an attachment to...

swiedner (3/22/2010)

---

The statement

"never acquires more memory than the level specified in max server memory."

Does that mean, that it will not ever use the page file then? That statement tells...

No idea! Misremembering something, answers on a postcard as to what. :laugh:

Of course the only way such an expression is...