is there a performance problem or something that really requires those threads to be killed, or is it something you noticed and it bothers you?

a sleeping thread is not necessarily...

not enough information to give anything but a generalized guess;

There's two obvious places there is a slowdown :

if your web pages are in .NET, they are not compiled/loaded into memory...

Faye Fouladi (8/31/2009)

---

I have a classic asp page that is accessed via different pages. In some situations the:

Request.QueryString("Contract_ID") is a vchar(100) and sometimes is coming a GUID.

When it is vchar(100)...

here's one I use that was posted by Jesse Roberge ; note this one features the 2005 option where you can INCLUDE other columns in the page data so it...

well there are two ways to do it via TSQL;

the preferred way is like this:

ALTER LOGIN Victoria WITH PASSWORD = 'B3r1000d#2-36';

the old procedure sp_password can be used as well,a t...

I'd seen this before;

here's how i've done it, and i broke it down to help everyone understand.

the way it works is the first 3 digits is the century julian offset,...

Grant Fritchey, who contributes a ton of time helping people here on SSC wrote a couple of ebooks that you can download for free right here on SSC:

SQL Server...

Glad my example worked out for you;

sometimes it's the forest and the trees...hard to see the solution until you step back a bit.

i saw you are using functions that return...

would something like this be a good idea to create a stored procedure with those commands, and have EXECUTE AS with sysadmin rights, then grant rights to the proc for...

are you sure the view in question qualifies as an updatable view?

that could be the issue with your CLR, rather than CLR itself.

i'm not sure, but ot looks like you want to parameterize the value for @COI_Shell , right?

Is this what you are looking for?(I guessed on the datatype)

CREATE PROCEDURE MyProcedure(@COI_Shell int)

AS

BEGIN

SET...

something like this is the way i interpreted it:

SELECT

VIEW1.ITEMNMBR,

VIEW1.ITEMDESC,

VIEW1.ABCCODE,

VIEW1.UOMSCHDL,

Month6 + JobMonth6 AS TotMonth6,

Month5 + JobMonth5 AS TotMonth5,

Month4 + JobMonth4 AS TotMonth4,

Month3 + JobMonth3 AS TotMonth3,

Month2 + JobMonth2 AS TotMonth2,

Month1 +...

if you are using SQL2505, you can convert the TEXT to varchar(max), but if you try and view the results in SSMS, you will still have the same issue identified...

I often want to search for a specific string that was posted by a specific author; so searching for "Jeff Moden"+"Tally" yields lots of results to dig through for the...

dambuster (8/25/2009)

---

Hi all,

What I would need to know is if it is possible to create databases with a format of an older version of Sql Server from Sql Server 2008.

I...