Have a look at ANSI_PADDING

This sounds more and more like the shopping basket analysis (OLAP).

Old example of beer and nappies.

Try 1, not generic enough

Set NoCount on

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TResp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[TResp]

GO

CREATE TABLE [dbo].[TResp] ([Resp] [char] (1) NOT NULL...

Try :

Select IsNull(gender,'None'), count(*) from ulist where status=1 group by gender

Should'nt a.STORE_ID be part of the join between the tables

BOL 2000, explains differential backup. Search for "Differential Database Backups".

Maybe you should try and explain the severity of situation to the CEO again. Cost of losing data(disruption to business) versus...

Previous solution on this site was

Select Top 20 *

From (Select Top 60 * from Table)

Order by Col1 Desc

A sp with @From and @To parameter.

One possibility is through linked servers.

See

http://www.sqlmag.com/Articles/Print.cfm?ArticleID=4829

Also try

http://www.sqldts.com/

Lots of examples

Anyone using sp_cycle_errorlog and if why?

Have heard about a site with a 'BIG' errorlog which did not reset but otherwise never experienced any problems. The source of this info was'nt...

Another penny, move the conditions from the WHERE clause into the ON clause. The IS NULL wont' be movable, I think.

Agree with 'dbcc showcontig' and I think we also used 80% as a threshold.

A bit of quick and dirty.

Enhanced from BOL 2000 example

DECLARE @idoc int,

@doc varchar(1000),

...

Can you post the query / hints?

Personally do not like distinct.

Results:

groupid TaskId Created ...