Viewing 15 posts - 4,186 through 4,200 (of 6,216 total)
May 28, 2002 at 11:33 am
Not exactly. See if this helps any:
http://www.sqlservercentral.com/columnists/sjones/pagesize.asp
Andy
May 28, 2002 at 11:32 am
Always diagnose the connectivity first. Ping and tracert are great for a start, but sometimes you'll find that its network congestion, bad router/switch, or any of a few other problems...
May 28, 2002 at 11:22 am
Look at cpu count along with the those numbers when you profile - given a choice of the scenarios where the # reads are the same (or about) I'd go...
May 28, 2002 at 11:20 am
Just to clarify, you want logical reads to be higher than physical reads (this is based on caching, if you're low on memory or its the first time in a...
May 28, 2002 at 8:27 am
May 28, 2002 at 8:23 am
Havent run into this before myself, but it seems to be common in the newsgroups, #1 suggestion I saw was to check the regional settings on your machine. Take a...
May 28, 2002 at 7:28 am
May 28, 2002 at 6:59 am
Sounds like a cursor might be appropriate. If you post some code we might be able to offer other/better options.
Andy
May 27, 2002 at 6:57 am
I don't see it anywhere, possibly its undocumented and resides in a dll? Or just code that exists within the restore code.
Andy
May 27, 2002 at 6:22 am
May 27, 2002 at 6:17 am
Try this:
Dim oserver As SQLDMO.SQLServer
Dim oJobServer As SQLDMO.JobServer
Set oserver = New SQLDMO.SQLServer
oserver.LoginSecure = True
oserver.Connect "servername"
oserver.JobServer.Start
Andy
May 26, 2002 at 4:29 pm
You have to do the work, SQL isn't any help. One decision you have to make early on is whether you'd have more than one person allowed to edit a...
May 26, 2002 at 12:02 pm
You can accomplish that by have each user "own" a table. That means either NT authentication or a separate sql login for each user, plus create table permissions for those...
May 26, 2002 at 5:59 am
Do you have logging enabled for the plan? Its on the last tab. Also have it write the text report to a file. If you run the job manually what...
May 26, 2002 at 5:54 am
Viewing 15 posts - 4,186 through 4,200 (of 6,216 total)