Viewing 15 posts - 30,541 through 30,555 (of 39,754 total)
As a compromise, you might prefix things with sp only, as in spMyProc. This doesn't cause the performance issues.
Or you could do uspMyProc, which is something I've seen. A short...
December 1, 2007 at 12:46 pm
You can monitor fragmentation with dbcc showcontig and then based on the results, decide which indexes you want to rebuild. Lots of scripts here on the site.
Other than that, SQL...
December 1, 2007 at 11:54 am
You need to create a connection on Server A, then perform the backup using this connection.
An ActiveX task is needed to perform the copy. The FileSystemObject in VBScript is probably...
December 1, 2007 at 11:53 am
The IP doesn't matter. SQL Server will bind to the host's ip.
The name does matter. You need to run
sp_dropserver
sp_addserver , local
and then restart SQL server.
December 1, 2007 at 11:50 am
Good points.
December 1, 2007 at 11:49 am
Either book is fine. I'm partial to Brian's book, but he's a business partner of mine, so I tend to use his resources.
I'd also look at sqlis.com
December 1, 2007 at 11:47 am
The way to do this is call the stored procedure from the ActiveX script. Then you can get an output variable or result set.
http://www.thescripts.com/forum/thread498718.html
DTS doesn't do a great job of...
December 1, 2007 at 11:46 am
What is the function doing? I tend to agree with the advice above, but I'm curious why you have two databases. Also, hard to tell if there is a performance...
December 1, 2007 at 11:44 am
I'd use a single database, create a table, and then populate it with the names of the databases from master.dbo.sysdatabases. I'd then run a loop through this table and execute...
December 1, 2007 at 11:43 am
Take the code out of the stored procedure and you should be able to use one of those. There aren't many ways to do this, so I'd use that code.
Is...
December 1, 2007 at 11:41 am
Target servers are typically remote servers sharing the plan, not the local server. The server you are connected to is the local server.
December 1, 2007 at 11:36 am
Don't know, but I'll pass it along.
November 30, 2007 at 3:52 pm
First, you don't want to shrink as a general rule. Keep that in mind and try to avoid it.
Second, in your case, it makes sense, but SHRINKFILE doesn't move data.
You...
November 30, 2007 at 10:02 am
I wonder. Will let you know. I talked to a few owners that were in the high tens (80-90k) and no issues so far. Hadn't noticed issues with less power/charging.
We'll...
November 30, 2007 at 9:37 am
Very strange. If you manually run a full backup and then a log backup immediately afterwards, does that work?
November 30, 2007 at 9:31 am
Viewing 15 posts - 30,541 through 30,555 (of 39,754 total)