Nice script. Could be modified to show which are the ones with elevated fragmentation.

MMartin1 (5/28/2014)

You could try

WITH Ordered AS

(

SELECT*, ROW_NUMBER() OVER ( PARTITION BY name ORDER BY Id) AS RN

FROM #mytable where ID

in ('TIX123','TIX999')

)

select * from ordered

where RN=1

to move the...

With batches, it is meant you can try something like

WITH Ordered AS

(

SELECT*,

ROW_NUMBER() OVER ( PARTITION BY name ORDER BY Id) AS RN,

ROW_NUMBER() OVER ( ORDER BY...

You could try

WITH Ordered AS

(

SELECT*, ROW_NUMBER() OVER ( PARTITION BY name ORDER BY Id) AS RN

FROM #mytable where ID

in ('TIX123','TIX999')

)

select * from ordered

where RN=1

to move the data...

Keep a watch on the distributor's transaction log, make sure it doesn't fill to capacity or that will halt things.

It could just be the report server that renders the report may be low on Ram or disk space, running a heavy process (maybe a anti-virus scan). Have you looked...

I would take a cursor over a triangular join if I was reporting on a running total in a columns. That's once instance.

I'm going to take a wild guess here. You have a exec SP in your ole db datasource ... that itself inserts data to a table... and is also passing...

You could use SSIS to guess/generate an XSD for you. Create a data flow task with an xml source. If you have the XSD file then even better. Dump the...

hi Lowell,

I'm curious why you need the +1 in the query

use msdb;

GO

DBCC CHECKIDENT ('dbo.backupset')

SELECT MAX(backup_set_id) + 1 FROM dbo.backupset

if the current identity is less than the max row in...

Not sure. Has the agent account password changed recently? Has disk space on the distributor filled up? Is the transaction log full on the distributor database?

For the current month ...

WITH MYCTE AS (

SELECT row_number() over (order by [dates] DESC ) as dayNum, [dates], datename(weekday, dates) as [Day Name]

FROM

( /* the last seven days in...

Perhaps the OP simply forgot to include the other cases in the where clause

ChrisM , If I can borrow your code...

Use ProdDB

SELECT TOP (100) PERCENT

[Prod No] = p.ProdNo,

[Prod...

Just want to mention that I have an old fashioned way of dealing with no data. Be mindful that your report viewers may want to see items that 0 counts,...

SSIS is a great tool.Once you connect to your data source within a dataflow task you can create a derived column. Here there are built in string and other operators...