Viewing 15 posts - 16,756 through 16,770 (of 39,901 total)
There is no implication in the question, at least not from what I read, that RG was enabled and disabled. It is "disabled" for non-internal groups by default, and doesn't...
March 3, 2011 at 9:43 am
There is no trick. When we specify drives, you should assume physical drives. The same applies on the Microsoft exams. There is no intention to trick you or come up...
March 3, 2011 at 9:37 am
Dizzy Desi (3/2/2011)
March 3, 2011 at 9:35 am
BrendaD (2/28/2011)
Who is the audience for such comments? Or more importantly, who are you trying to exclude?
Just wondering...
March 3, 2011 at 9:28 am
OCTom (2/28/2011)
The martial arts maxim sounds backward to me. Isn't it that the improved performance of an individual in a group improves the overall performance of the group?
I don't think...
March 3, 2011 at 9:26 am
If you have new hardware, you will install the new software on it, then move logins
Login migration: http://www.sqlservercentral.com/articles/934/
Move over databases from either a backup/restore or detach/attach, then script out alerts/operators/jobs...
March 3, 2011 at 9:23 am
Yes, it's a bug in the system when two people are posting at similar times. Low priority, but it's on our list.
March 3, 2011 at 9:21 am
You haven't asked a question. You made three statements.
You can install SQL Server on one, and the client tools on the other machine and have them work. You will have...
February 27, 2011 at 10:32 am
That typically means you specified the instance name as "inactive" when you installed it. It's a name, but shouldn't affect the SQL Server.
It is off topic for here. If you...
February 27, 2011 at 10:25 am
Did you add a filegroup for your database that includes filestream data? If you look at the database creation script in the article, you will see (emphasis mine):
USE MASTER
GO
...
February 27, 2011 at 10:23 am
LOL, glad it worked. Note, that you shouldn't be shrinking the log regularly. If you need that space for index rebuilds, leave the log where it maxes and let is...
February 26, 2011 at 9:48 am
replication enabled? If not, I might suspect that you have a large VLF that's active. The log is divided up, and depending on how it was sized and grown, you...
February 26, 2011 at 8:55 am
Filestream has to be enabled in SQL SErver (sp_configure) and also in Configuration Manager, as a note to the OS that this is allowed. So two settings to change.
Then check...
February 26, 2011 at 8:53 am
Are you migrating to new hardware or upgrading in line?
No matter what, be sure you have good backups of all databases ( including master/msdb) on another machine before you start.
February 25, 2011 at 6:39 pm
Viewing 15 posts - 16,756 through 16,770 (of 39,901 total)