You should review the logic for @bucketID's 9 through 12.  The logic appears to be the same for each one - with minor differences.  You should be able to reduce...

I can see the advantage of being able to pre-populate a table at the defined fill factor - for those rare cases where it is needed.  I have reviewed your...

The way the schedules are set up - they use 4 yearly schedules.  One for each quarter...and it looks like the next scheduled run time for that schedule isn't until...

SQL Agent job history will be purged by default - and the default settings are not generally good enough.  If you left the default - then most likely the reason...

What makes you think the subscription did not execute?  Did you review the subscription in SSRS - or view the job history for this job?

The job schedules all appear to...

Is WW the week number - or month number?  If week number - is it ISO week or US week?

• This reply was modified 5 years, 5 months ago by Jeffrey Williams.

The problem here is that a single row cannot have both a value of 'mStatus' and a value of 'Sub1' at the same time in the column v2.FieldT.

What you are...

Execute this to see the fillfactor in use. You would expect 50% right?

DBCC SHOWCONTIG (tbl_user);

You are wrong. SQL Server uses 100% no matter what.

What happens if we rebuild...

If they are not on the same network - it doesn't matter.  You cannot connect to an IP address on another network unless there is...

Your query shows t.value - but the problem states the issue is t.fieldValue.  Can you provide a set of sample data in the form a create/declare statement for the table...

Round up to what?  You are getting an average of the number of seconds which will be a whole number - for example you could have an average of 23,...

If the PC's are not on the same network - how are you going to connect to the other PC?  You have to be able to define a route to/from...

When you state you are working remote - what exactly does that mean?  Are you trying to access servers on a corporate network from home?  If so - you cannot...

BWAAAA-HAAAAAA!!! Some of my fellow older folks in the crowd will have an appreciation for...

A couple of things - first, using '%harch%' requires a full table/index scan because of the leading wildcard.  Second, you need to review the code in the view to see...