Viewing 15 posts - 1 through 15 (of 17 total)
We have 150 SQL Servers & 3000+ databases. Autogrow is the standard & we reindex weekly at minimum. We use home grown code & batch jobs to retrieve...
May 5, 2008 at 7:38 am
Good article. Reminds me of a gripe I have about MS, though. In Enterprise Manager, using external tools, you could open explorer on the server where you had...
December 26, 2007 at 8:13 am
Was this ever resolved? We are missing ODBC drivers (including ORACLE) on our 64 bit SQL Server 2005 environments. Server operations group installed the Oracle client, but the drivers are still...
February 28, 2007 at 9:58 am
I'm a guy, my daughter is in college and yes, I've encouraged her to pursue a career in IT. That's entirely her decision, but I wouldn't think of discouraging her...
February 14, 2007 at 10:24 am
I agree with SAM, sort order/collation should be a major consideration, if you're in anything but a tiny shop - we have 5 different flavors here. Putting a user database on...
November 16, 2006 at 10:39 am
Worked good, after figuring out not to use quotes for the input variables, and then a problem encountered when the sqlcmd couldn't log on:
Restarting service with /f and trace...
October 17, 2006 at 4:21 pm
Yes, you'd need to do the same with those. Make sure the drive letters & folders are the same on source & target servers.
This method is rather easy, and a...
September 25, 2006 at 9:42 am
Is the new server going to be renamed the same as the old one?
Here's what we do in a nutshell - if the drives are the same & this is...
September 22, 2006 at 10:04 am
Nothing in the event logs anything like that.
September 8, 2006 at 11:31 am
Oops, I meant to say he suspects the MAXTRANSFERSIZE default is hardware dependent, not memory dependent.
September 7, 2006 at 2:15 pm
Passed this on to our server guy, he said we use NIC Teaming, but only in a smart failover configuration, not load balancing. No drive failures.
8 SAN attached servers are...
September 7, 2006 at 2:13 pm
Couldn't say for sure, but I doubt it. I notice that MS article 224071 (How to move SQL Server databases to a new location by using Detach and Attach functions...
June 29, 2006 at 8:40 am
External tools also don't work the same in sql2k5. We manage 100+ sql server environments, so using the [SRV] parameter in sql2k EM external tools is handy for executing explorer,...
March 24, 2006 at 8:11 am
External tools also don't work the same in sql2k5. Managing 100+ sql server environments, using the [SRV] parameter in enterprise manager's external tools is handy for accessing explorer, server...
March 16, 2006 at 11:49 am
We're having the same issue on a production server here. Applied SP4 & then the 2162 hotfix due to trying to fix strange problems.
Ended up bad data being bulk-copied...
January 20, 2006 at 9:14 am