Viewing 15 posts - 106 through 120 (of 156 total)
The fact that BOL states "All requests to the cursor are answered from this temporary table in tempdb" for STATIC cursors led me to believe FAST_FORWARD is better, especially for...
July 8, 2008 at 7:41 am
To some degree, I think the value of certification depends on what the market demands. Currently, I think there is a fairly high demand for SQL Server DBAs so employers...
July 3, 2008 at 8:48 am
Check the security context for the linked server? It may not have execute rights on remote server.
June 25, 2008 at 7:32 am
I agree with those who mention coming in early before everyone else. It gives you time to check on things and, if there is a problem, time to fix it...
June 23, 2008 at 8:04 am
One thing is for sure, based on the responses, we have a lot of passionate users in this forum! I too chose #2 and was zapped.
June 23, 2008 at 7:25 am
Try adding two single quotes at the end of your string creation:
set @STR='Exec Master..xp_Cmdshell ''osql -E -S NLLSJAWOO -d CVR -h -n -s; -w1000 -q "Select * from...
June 20, 2008 at 8:07 am
Check out the following post: http://www.sqlservercentral.com/Forums/Topic258367-23-1.aspx
June 18, 2008 at 7:47 am
Ideally, you should not have to work extra because of vacation. Practically, it usually never happens that way. One of the reasons I hardly ever take vacation is because of...
June 13, 2008 at 8:01 am
I've always had good things happen on Friday the 13th. Although, I'm planning on getting on a ladder and painting the house this evening...maybe I should hold off.
June 13, 2008 at 7:22 am
After ruling out other jobs or processes running on the server, check to see if there are any bad disks on the server. I ran into a similar problem and...
June 10, 2008 at 7:36 am
Does your stored proc have an output parameter? If not, add one in the code to output the sum. Then execute as follows:
Declare @ret int
exec sp_SumTolat @ret output
select @ret
June 9, 2008 at 8:41 am
Wrap your dynamic SQL in a WHILE loop with MaxCount as its limit. This solution is good if you don't have too many records to deal with. If you have...
June 9, 2008 at 8:18 am
Viewing 15 posts - 106 through 120 (of 156 total)