Viewing 15 posts - 7,381 through 7,395 (of 9,241 total)
have you exposed the LUN to both servers?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2010 at 7:12 am
MysteryJimbo (11/18/2010)
Guestimate of 6 x 2Gb to ensure proportional fill.
Could be overkill, how many logical processors do you have?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2010 at 8:53 am
I would also add the auth_scheme column to Lowell's query to check for NTLM or Kerberos authentication type.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2010 at 7:49 am
are you looking to get the IP address of the client connecting to SQL Server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2010 at 5:17 am
Scott Ohar (8/11/2009)
Hmm, thats odd. I've had no issues, just stating how to address that issue which a clustering engineer from microsoft recommened to do.
I have only seen this when...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2010 at 3:03 am
Be aware the shrink may have no effect on some log files. If the active portion of the log occupies the end of the file you may not shrink below...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2010 at 1:57 am
paul.olson.dba (11/15/2010)
I have tried rebuilding indexes,
this is a known issue, it's almost certainly the indexes holding the space. The data pages are not deleted just deallocated, it makes roll back...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2010 at 3:42 pm
why are you repairing, you were supposed to be adding a node on node b and selecting the existing clustered default instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2010 at 3:22 pm
BIDS executes under your windows user account so that will be golden 😉
Edit the data source properties in SSRS to execute in your preferred fashion (windows account, sql server account,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2010 at 1:22 pm
either the data source does not exist or it is in another folder on the SSRS instance. In report manager select the report and go to the data source option...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2010 at 11:58 am
hydbadrose (11/14/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2010 at 4:21 am
They never miss you until you're gone 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2010 at 3:43 am
phoenixrising1599 (11/14/2010)
I'll have to stand up a 2k instance
That's exactly what I do, any that just can't be moved for whatever reason, I consolidate to a centralised instance. Make 2...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2010 at 3:06 pm
Paul White NZ (11/14/2010)
How is casting binary or varbinary dependent on collation?
Character set conversions! In fact Unicode and instance version may have a bigger effect, I may well be wrong...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2010 at 2:17 pm
presumably your Windows page file occupies the C drive also?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2010 at 12:14 pm
Viewing 15 posts - 7,381 through 7,395 (of 9,241 total)