Viewing 15 posts - 61 through 75 (of 117 total)
Great topic Brad! Funny because there are often times in the office where Scott (Gleason) will say something then immediately turns to me and says "don't tweet that", as he...
September 5, 2010 at 5:39 pm
Graham, glad you're diving into the wonderful world of SQL Server! You can go a few routes:
1. Install it directly on your laptop OS (XP or higher)
Pros: Don't need to...
September 4, 2010 at 12:29 pm
Haha no problem. I didn't realize the sheer number of forums here until I went searching for the suggestions one. Maybe a spring cleaning wouldn't be too bad of an...
August 25, 2010 at 2:33 pm
You may want to create this thread over in the Suggestions forum instead: http://www.sqlservercentral.com/Forums/Forum4-1.aspx
August 25, 2010 at 2:16 pm
Check out this thread from MSDN forum: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/06c80a78-a877-4a48-a032-b0aef78a598c%5B/url%5D
August 25, 2010 at 1:46 pm
Maintenance plans are good...to a point. I highly suggest checking out Brad McGehee's book on Maintenance Plans (free download): http://www.bradmcgehee.com/2010/01/free-ebook-on-sql-server-maintenance-plans-now-available/[/url]
While the GUI is nice, you can still do what you...
August 25, 2010 at 1:44 pm
I'd imagine the downsides would really depend on your needs. Here's a nice post I came across detailing some potential issues with SB usage: http://datageekgal.blogspot.com/2008/07/sql-server-service-broker-archival.html
August 25, 2010 at 1:42 pm
Might as well link the existing article here on SSC on the topic: http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31605/[/url]
August 25, 2010 at 1:34 pm
All good advice regarding test environments. Here's a couple of good articles on handling change control management on your database systems:
http://www.brentozar.com/archive/2006/01/automating-sql-server-version-control-with-visual-sourcesafe/[/url]
August 25, 2010 at 1:31 pm
Ah cool you're absolutely correct, thanks for that reminder Gail!
August 25, 2010 at 7:23 am
I just came from an environment where I administrated over 100 instances by myself. Like Gail mentioned it really just depends on the level of automation you put into place....
August 24, 2010 at 10:52 pm
You can't restore to lower version of SQL Server but you can restore UP (i.e. restore 2000-->2005, 2005-->2008).
The problem in your case is 10.50.1600 is SQL 2008 R2 RTM...
August 24, 2010 at 10:45 pm
DBCC MEMORYSTATUS http://support.microsoft.com/kb/907877
August 24, 2010 at 10:39 pm
While I don't have the code for it, I'm pretty sure you could perform this task using PowerShell. Lots of good resources out there such as Chad Miller, Max Trinidad,...
August 24, 2010 at 9:51 pm
USE [demodb]
GO
CREATE USER [testme] FOR LOGIN [testme]
GO
USE [demodb]
GO
EXEC sp_addrolemember N'db_accessadmin', N'testme'
GO
USE [demodb]
GO
EXEC sp_addrolemember N'db_backupoperator', N'testme'
GO
USE [demodb]
GO
EXEC sp_addrolemember N'db_datareader', N'testme'
GO
August 24, 2010 at 9:39 pm
Viewing 15 posts - 61 through 75 (of 117 total)