Viewing 15 posts - 1,576 through 1,590 (of 3,232 total)
You've probably hit the tipping point on one of the server's resoruces to where things start getting exponentially worse. You may consider monitoring the box during the backup to...
October 8, 2008 at 12:30 pm
Here's a great example. This includes a comprehensive log-shipping solution, but you can pull out the full backup/restore pieces. I've implemented this at a place that has not...
October 8, 2008 at 12:26 pm
Why can't you use the data as-is in your stored procedure?
October 8, 2008 at 12:23 pm
In that case, you'll want to go with a multi-statement table valued function. Check in BOL for details, but here's a quick example.
CREATE FUNCTION dbo.udf_functest(@ID int)
RETURNS @ReturnTable TABLE (TranID...
September 11, 2008 at 3:04 pm
You don't need the table declaration section. The function itself is a table variable. Your function needs only to have the SELECT statement in it.
CREATE function...
September 11, 2008 at 1:52 pm
Is there a question here?
September 4, 2008 at 4:39 pm
So you're talking TempDB, not memory? Yes, restarting the service will shrink your TempDB back to it's original size, but I would only do that if you are out...
September 4, 2008 at 4:11 pm
Vika,
I just want to stress how important it is not to do anything that may use the original data drive until you've taken a shot at recovering the deleleted...
September 4, 2008 at 4:05 pm
All DML statements must first load the appropriate data pages into memory so using a derived table should not have an abnormal effect to your query. It needs to...
September 4, 2008 at 3:56 pm
Yep, that's it. I should emphasize the importance of setting ROWCOUNT back to 0 (unlimiited) because if you don't, SQL Server will use the limit that you've set for...
September 4, 2008 at 3:52 pm
Please don't cross-post.
This thread is continued here:http://www.sqlservercentral.com/Forums/Topic564222-8-1.aspx
September 4, 2008 at 3:43 pm
TOP does not allow for a variable value in SQL Server 2000.
You'll need to use SET ROWCOUNT:
declare @mytable table (zipcode varchar(10))
insert into @mytable
select '68144' union all
select '68132' union...
September 4, 2008 at 3:42 pm
A couple of quick querions:
1. Are you using the for loop container or coding your own loop in a script task?
2. What is the reason for the 2000 row batches,...
August 25, 2008 at 12:34 pm
Viewing 15 posts - 1,576 through 1,590 (of 3,232 total)