Very...

@Gail +1,000,000 - that's 99% the case here at our shop 🙂

Yes, that would be a concern, however, I alleviate this issue by using a scalar function to look it up 😉

CREATE FUNCTION [dbo].[fx_FetchSQLAgentJobID] (

@JobName char(250)

)

RETURNS uniqueidentifier AS

/*

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

Purpose:Returns the job_id for...

What kind of hardware do you have running?

If you suspect bad queries, look for ones that have especially high reads/long durations, as these may be potentially missing indexes...

John Mitchell-245523 (12/21/2012)

---

I would guess that you can't start a job remotely via a linked server. You could try using Powershell or SSIS instead. Or you could set...

I can't say for tempdb specifically but have noticed improvements for IO operations from other DB's running on SSD, I recommend you run some testing using IOMeter or similar tool...

Yeah that's kind of what I was thinking at one point but was hoping for a "magical" solution that someone might have out there based upon a similar situation 🙂

It...

I'm not certain where the disconnect is happening but again, I just set users up via the report manager granting the permissions I'd like them to have at the folder...

Do you actually need to physically render the report?

It is possible, but the method I know is rather "tricky" - it involves a little configuration, but can be accomplished.

First you...

Do you actually need to physically render the report?

It is possible, but the method I know is rather "tricky" - it involves a little configuration, but can be accomplished.

First you...

I'm not a big fan of reading XML query plans but a quick search through the XML revealed several IMPLICIT_CONVERSIONS, which depending on the number of records this occurs on,...

Perhaps this may be simpler:

use [YourDB]

GO

GRANT ALTER, EXECUTE, VIEW DEFINITION TO [DOMAIN\User]

GO

Based off what you've offered for information it sounds like something you could do in SSIS?

IMHO the threshold setting is a personal choice of when to chose to rebuild versus reorganize the index. The main difference between the two are basically: when rebuilding you...

@myself - ID10T error, of course! 8000 is the limit