I did this too quickly but maybe it will give you an idea. (Also it is not surgable).

SELECT

S.Supplier,

SL.StockLevel,

CASE...

GilaMonster (3/18/2014)

---

Yes

Check the...

Not sure where I got this:

-----------------------------------------------------------------------------------------

-- Database free space

-----------------------------------------------------------------------------------------

IF OBJECT_ID('tempdb..##DatabaseSize') IS NOT NULL DROP TABLE ##DatabaseSize;

CREATE TABLE ##DatabaseSize

(

DatabaseName sysname,

Name...

As stated this is part of the code I use to generate UPDATE STATISTICS command that I run manually. And since I did not create the indexes, I do...

Might also try:

Select * from Production

where ISNULL(DeviceName,'Keyboard') = 'Keyboard'

and Owner = 'Mark'

however, this does not use an index for DeviceName.

Here is part of the logic I use to refresh statistics:

select Object_name(object_id) AS TableName

, name as StatName

, STATS_DATE(object_id, stats_id) AS statistics_update_date

from...

Use cte finding the max time stamp into one table and the min timestamp into another. Use COALESCE to insert into a temp table before updating the original

Unfortunately I...

It seems to work for us.

If the value stop_execution_date is null in msdb.dbo.sysjobactivity the job is running.

Why not modify the first query to LEFT JOIN to msdb..Sysjobhistory?

We use views as the access point for users. (outside of company application) . This way we can limit the columns seen and just give readonly access to...

Just put a comma not a ;with between them

Just get your MAX as normal then add criteria to limit the range.

Please show what code you have so far.

Erland Sommarskog (3/6/2014)

---

What is the architecture of the application? Web app? Three-tier with a separate application server? Or does the user run the application from his desktop and the application...

I am old school. I have a folder that I keep code in. If I need to find something and cannot remember which sub folder, I do a...