Viewing 15 posts - 886 through 900 (of 1,583 total)
@Gail +1,000,000 - that's 99% the case here at our shop 🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 21, 2012 at 9:24 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 21, 2012 at 9:19 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 21, 2012 at 8:31 am
John Mitchell-245523 (12/21/2012)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 21, 2012 at 8:20 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 21, 2012 at 8:14 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 20, 2012 at 9:21 pm
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 20, 2012 at 9:17 pm
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 20, 2012 at 9:05 pm
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 20, 2012 at 9:04 pm
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,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 20, 2012 at 11:12 am
Perhaps this may be simpler:
use [YourDB]
GO
GRANT ALTER, EXECUTE, VIEW DEFINITION TO [DOMAIN\User]
GO
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 20, 2012 at 10:24 am
Based off what you've offered for information it sounds like something you could do in SSIS?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 20, 2012 at 10:13 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 20, 2012 at 10:09 am
@myself - ID10T error, of course! 8000 is the limit
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 19, 2012 at 11:25 am
Have you read through these two articles (related)
http://msdn.microsoft.com/en-us/library/aa337491(v=sql.105).aspx
http://msdn.microsoft.com/en-us/library/ms156034(v=sql.105).aspx
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 19, 2012 at 10:40 am
Viewing 15 posts - 886 through 900 (of 1,583 total)