Viewing 15 posts - 196 through 210 (of 247 total)
Normally, the best performance is obtained from SQL Server if you can use a set based query. A cursor or a loop should be a last resort unless the...
October 28, 2003 at 8:44 am
For this reason, I would also avoid xp_sendmail in SQL Server jobs. I've seen such a hang prevent scheduled jobs from executing. There are other options. I...
October 28, 2003 at 8:18 am
The debugger interface is required on the client.
October 23, 2003 at 9:40 am
quote:
quote:
I like to put the drop in myself. Sometimes to debug a procedure,...
October 23, 2003 at 9:28 am
If you are talking about the SQL Server Error logs, try looking up "Using Startup options" in BOL. There should be an -e parameter specifying the path to the...
October 21, 2003 at 1:33 pm
Is a SET NOCOUNT ON required while processing the temp table?
October 21, 2003 at 1:07 pm
quote:
...the upgrade changes the -- by removing it....
This sounds like a serious bug to me....
October 17, 2003 at 8:39 am
On advantage of using a job step is that the step history will contain information from prints or raiserrors. Comes in handy. Good luck in finding this output...
October 17, 2003 at 8:27 am
I have found that using a join normally produces a faster query.
SELECT t1.*
FROM #temp1 t1
LEFT JOIN #temp2 t2
ON t2.ID = t1.ID
WHERE t2.ID IS NULL
October 16, 2003 at 9:41 am
I would also make sure that your public roles do not have object permissions.
October 16, 2003 at 9:34 am
The conversion might be tricky. In the old style, the where clause is applied before the join while in the new style the where is applied after the join....
October 16, 2003 at 8:55 am
Some of our developers decided to break up dbs into dependent pairs. They append the word "_stage" to one of them. The pair exists in the dev, staging,...
October 16, 2003 at 8:38 am
One of our databases is used to control access and resides on many of our SQL Servers. From time to time, a request comes through to refresh a set...
October 16, 2003 at 8:04 am
You can also use a different query in each case. I resort to this when I can't get one query to execute quickly for all cases. This query...
October 16, 2003 at 7:43 am
Connections, file paths, exchange profiles, etc. in your package will probably not be valid at the destination. If you know what they should be, disconnected edit can be used...
October 15, 2003 at 11:30 am
Viewing 15 posts - 196 through 210 (of 247 total)