Viewing 15 posts - 751 through 765 (of 823 total)
I've vacillated a few times over the DH. For years I hated it, thinking that it took away from the purity of the game, wanting pitchers to step up...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
July 12, 2010 at 9:57 am
Thanks for the info, Cindy. I'm forced to use GRID to monitor my SQL Server instances and this type of information is useful, as I've never tested that metric.
Side...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
July 12, 2010 at 9:26 am
Just giving this a bump, hard to believe that the community is not using this type of software. Would love to hear from y'all.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
July 12, 2010 at 8:23 am
Wish it meant something more, I'd love to see more intensity than just whatever pride generates. To see the best of the best go at it like it was...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
July 12, 2010 at 8:21 am
One reason I've set our named instances to specific ports is our firewall rules. We want control over over which machines connect to our databases, even if it means...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
July 9, 2010 at 3:12 pm
Just found this thread, fun stuff. Giants fan here, NL West is crazy insane. I'm not holding my breath, though.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
July 9, 2010 at 11:45 am
Can you use the NOCHECK option on the constraint?
I. Disabling and re-enabling a constraint
The following example disables a constraint that limits the salaries accepted in the data. NOCHECK CONSTRAINT is...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
July 1, 2010 at 5:15 pm
http://msdn.microsoft.com/en-us/library/ms143504.aspx
BoL has great info...on that page check out 'Viewing Windows permissions for SQL Server Services'.
There's a MS white paper also, google 'microsoft best practices sql server', you'll find a link...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
June 30, 2010 at 11:38 am
Google is an awesome tool:
http://msdn.microsoft.com/en-us/library/ms143269(SQL.90).aspx
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
June 8, 2010 at 7:30 am
Thanks again. I had done the same Googling considering the ramifications of the TRUSTWORTHY setting and saw similar results.
Interesting idea with a monitoring job. I'll look at my...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
May 27, 2010 at 12:16 pm
I've finally finished my version of the stored procedure, and indeed, as you stated, Lowell, I need to change the TRUSTWORTHY property of the 'master' database to ON for this...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
May 27, 2010 at 11:13 am
Try single user mode then:
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
May 4, 2010 at 3:27 pm
Do have the administrator password to the Windows server administrator account that the database instance resides on? If so, and if the former admin did not remove the BUILTIN/administrators...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
May 4, 2010 at 3:16 pm
I've just recently set up Oracle Enterprise Manager 10.2.0.5 GRID control and the SQL Server plugin needed to monitor the SQL Server instance, here's some of my experience:
If you're using...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
April 29, 2010 at 10:59 am
"This is not 'Nam, this is bowling....there are rules." - Walter Sobchak
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
April 26, 2010 at 2:36 pm
Viewing 15 posts - 751 through 765 (of 823 total)