--Query

SELECT

DB_NAME(dbid) as DBName, status,

COUNT(dbid) as NumberOfConnections,

loginame as LoginName

FROM

sys.sysprocesses

WHERE

...

But the system has been operational for 1 1/2 years without throwing this error. The load has not changed dramatically. In the past week a number of MS...

Ah, so I should enter a real number. EX 2GB for OS, remainder for SQL?

In SSMS under server properties we're using the default. It seems that these values are being used by the server. When we watch the server the memory usage...

To clarify, the drop/recreate of the procedure did likely recompile the procedure. My test was focused on whether or not the changing of the data in the temporary table,...

To follow up, I ran some tests in SQL2008R2. The execution plan is cached. I performed similar test as those in the article by running queries against the...

Thanks for the responses. Looking forward to testing and validating.

ST

Thanks for the reply. In my case it may be beneficial. I'm trying to weigh whether or not to add the WITH RECOMPILE to these procedures. Sometimes...

Thanks for the replies. I always thought that the BEGIN and END statements defined the procedure. Thanks for the schooling. This was a case where a GO...

Select * INTO #TMP FROM(

SELECT '1A14487' as PartNumber, Convert(Datetime,'8/4/2013') as InspDate, '.1101VAS073-7' as MfgSerial UNION ALL

SELECT '3L11593', '1/28/2014', '009VAS206-1' UNION ALL

SELECT '3L11593', '1/29/2014', '009VAS206-1' UNION ALL

SELECT '3L11593', '2/21/2014', '009VAS206-1' UNION...

It's not too hairy. I don't know how it would perform against a large data set. This was an interesting exercise.

SELECT * into #TMP FROM (

select '01' as...

I agree, it's the many calculations that lead up to the sum. As a test I took the output of the view, 500+ records, and stored it in a...

The data does not change between runs. It's static. You can run the non-rounded version a million times and it always returns the same.

Higher up the chain...

Thanks for the replies. I think I'm going to add an aggregate (reporting) table to the application to make this initial information easier to find and faster to load....

I'm not familiar with pivot tables per se but one of the following should work...

select

[Location_Code] AS 'Location Code'

,[Gt 0-1], [Gt 1-2], [Gt 2-3], [Gt 3-4],

[Gt 0-1] + [Gt 1-2]...