If you mean timeout values, you can change that in your connection configuration for the application. As Gail mentioned, it's not usually an SQL Server property. There is...

Sean Lange (4/16/2012)

---

Brandie Tarvin (4/16/2012)

---

WayneS (4/16/2012)

---

Brandie Tarvin (4/16/2012)

---

If any would-be employee claims to be a Threadzian, we have two questions that we can now ask them during the interview.

2) How...

capn.hector (4/13/2012)

---

ok on topic: http://www.sqlservercentral.com/Forums/Topic1283271-392-1.aspx how do you long time posters keep going when you run into people like this. (one thread there are more out there)...

The only kind of function you can insert rows into in SQL Server is a single-table inline-table-value-function.

Those are defined like:

create function dbo.MyFunction (@Param datatype)

returns table

as

return (select columns from dbo.MyTable where...

The two main drawbacks to indexed views are the limits caused by schema-binding, and the fact that they do slow down insert/update/delete operations. They also require the usual maintenance...

You don't need to know the bad characters at all. White-list, don't black-list. It's more secure, easier, and faster.

You could modify my version to use a table of...

L' Eomot Inversé (4/13/2012)

---

SQLRNNR (4/12/2012)

---

Steve Jones - SSC Editor (4/12/2012)

---

Both printers here are acting up. One doesn't want to inject ink on the the paper. The other keeps sending...

To the original question: Apply. I've rarely seen a "need a DBA" ad that didn't list impossible, silly, contradictory, or psychotic requirements, and sometimes more than one of those....

On seconds runs (taking advantage of caching), my update-only version of your script took about 11 seconds, while my script took 3.8 seconds.

jcrawf02 (4/12/2012)

---

GSquared (4/12/2012)

---

I'm in the top 25 (usually in the top...

You can't compare a Select to an Update.

Here's a test of my method, using the test data you came up with:

SET NOCOUNT ON ;

IF OBJECT_ID(N'tempdb..#t') IS NOT NULL

...

Should be fine then, I would think.

Shrinking data and log files usually just results in them filling up and growing again. With the added benefit, in the data file, of fragmenting your indexes and thus...

Lynn Pettis (4/12/2012)

---

GSquared (4/12/2012)

---

Lynn Pettis (4/12/2012)

---

GSquared (4/12/2012)

---

Eugene Elutin (4/12/2012)

---

...

It's entirely possible someone with better C#/VB.NET skill than mine can make a CLR function that's faster, but the options I...

I'm in the top 25 (usually in the top 10), and...