Viewing 15 posts - 26,701 through 26,715 (of 39,792 total)
It is as long as your DR system supports that as well. If not, I'd split only as needed for DR.
Performance wise, no reason a 1TB or a 10TB file...
October 13, 2008 at 9:31 am
What's your idea of "healthy"?
I see that used, but it could mean many things. A short list of stuff I'd do first.
1. Make sure backups are being run.
2. Make sure...
October 13, 2008 at 9:29 am
Or if you want multiple ones.
Be sure that you use () to block out your ORs and ANDs. AND would match nothing since (I assume) you can't have a single...
October 13, 2008 at 9:27 am
You don't see a subquery.
use [database]
UPDATE Table1
SET ProblemType = 12
WHERE problemType = 32
The way you had it written, you were updating all rows.
October 13, 2008 at 9:11 am
Should be able to type it in there, or use the search feature.
They add just like AD users as logins.
October 13, 2008 at 9:07 am
The way to stop deadlocks is to trace them down and then fix the code so it doesn't allow deadlocks.
October 13, 2008 at 8:29 am
Can I ask why the first column is a problem? Perhaps we have another way to do this.
Honestly any other way than dealing with this in the client is asking...
October 13, 2008 at 8:28 am
I'd use a batch file, and put the file names in there. You need to control ordering at times, so I'd be wary of a script like the one above.
http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/vcspart3/525/
October 13, 2008 at 8:27 am
First, this isn't really a backup question. Please post in the correct forum (moved to admin).
Second, dbcc checkdb is a good place, but what do you mean by health check...
October 13, 2008 at 8:25 am
sleeping connections are still connected.
No one should show that db name in sp_who2. If they do, you need to remove them. That includes you connected with SSMS.
October 13, 2008 at 8:24 am
It's a communication issue. Can you give the names you used and are you sure the service is running on the 1st computer?
October 13, 2008 at 8:22 am
Is this a one time thing or regular? If it's one time, use the data export, and import, wizards.
You can use those if it's regularly, but I might suggest something...
October 13, 2008 at 8:21 am
Gail has the right idea. My Computer/Manage/Services, check for the MSSQLServer service and see if it's running. You can netstat-a and see if the listener is running.
Are you connecting locally,...
October 13, 2008 at 8:20 am
You can do this, but it's asking for trouble. It increases your surface area and potentially exposes you to sql injection.
The only thing I might do it read the "from"...
October 13, 2008 at 8:19 am
You wouldn't use shrinkfile to move data. It reclaims physical file space for the OS, does nothing to effect the data.
The problem is that unless you add data equally to...
October 13, 2008 at 8:17 am
Viewing 15 posts - 26,701 through 26,715 (of 39,792 total)