Viewing 15 posts - 15,871 through 15,885 (of 39,970 total)
Good to hear. I'm not a regular expressions expert, or at least not anymore.
If you need more complex changes, I might contact the author of the article and ask...
June 20, 2011 at 3:13 pm
GabyYYZ (6/20/2011)
Anyone know if he has official Microsoft MVP designation, either now, or in the past?
AFAIK, he never has. Not enough contributions to the SQL Server community, and not sure...
June 20, 2011 at 12:04 pm
Multiple instances are being used for two main reasons
1 - licensing (some cheaper benefits here over separate servers/VMs)
2 - tempdb loads - If you have heavy tempdb (and lower memory/CPU),...
June 20, 2011 at 12:03 pm
It's a load issue, not a number of databases. I know people that have had upwards of 500 databases on an instance, and it's worked well, but each was low...
June 20, 2011 at 11:27 am
We've talked about this, but the main issue is the person asking the question is the least qualified to say if something is the answer. Often a suggestion is made...
June 20, 2011 at 11:25 am
I'm with GSquared. I've never seen a reason to move SQL Server binaries anywhere. It's the data, log, and backups that are important.
June 20, 2011 at 9:46 am
Does this help?
http://www.simple-talk.com/sql/sql-training/regex-based-finding-and-replacing-of-text-in-ssms/
June 20, 2011 at 9:42 am
I don't think you can change this. The tabbed layout was a fundamental change.
June 20, 2011 at 9:41 am
We used a variation of this for weekly releases for well over a year, which included database design changes.
We could spend a few hours on db design, debating the changes...
June 20, 2011 at 9:40 am
Rich Weissler (6/20/2011)
June 20, 2011 at 9:27 am
No idea, might be a T-post, but I can't find anything. Just found the horse like this, blood in a stall.
Much better now.

June 18, 2011 at 1:01 pm
Another confirmation, multiple log files do not provide any benefits.
For multiple data files, you get benefits only if you can separate out the reads and writes of heavy objects to...
June 18, 2011 at 10:32 am
I tend to agree with Jeff, but you can add a TicketDate with a datetime value, and if needed, you can display a combination of your Year, Department ID, and...
June 18, 2011 at 10:14 am
Kiara (6/18/2011)
Steve Jones - SSC Editor (6/17/2011)
June 18, 2011 at 9:54 am
The server name is your machine name.
For express, it's often machinename\SQLExpress. You should be able to scan for them.
June 18, 2011 at 9:50 am
Viewing 15 posts - 15,871 through 15,885 (of 39,970 total)