Viewing 15 posts - 2,386 through 2,400 (of 3,232 total)
This script will work in terms of limiting the rows in each batch, but you need a way to determine if the rows already exist in the target table. As...
March 8, 2007 at 10:08 am
I am assuming that your current Recovery Model is Full. You may want to consider switching it to Bulk-Logged temporarity while you are moving your data over. If you are...
March 8, 2007 at 9:22 am
Also, I would recommend leaving it alone unless you've got a good reason to decrease the memory available to SQL Server. If this is a stand-alone server, give SQL Server...
March 7, 2007 at 4:25 pm
Your [Data] column must be a varchar? To get it to order correctly, you'll need to strip out the MB value and convert it to a numeric value. For example:
DECLARE...
March 7, 2007 at 4:18 pm
If you have > 2 GB of memory and you are using AWE, you will also want to apply this patch after the SP4 upgrade:
March 7, 2007 at 3:42 pm
PW beat me to it, but here's another flavor.
SELECT e.RespondentID
FROM EventLog e
INNER JOIN tblLookup l
ON e.RespondentID = l.RespondentID
LEFT JOIN (SELECT DISTINCT RespondentID FROM EventLog WHERE...
February 28, 2007 at 2:35 pm
Well, when you set up your trace, make sure that the DatabaseID column is listed in the 'Data Columns' tab on the Trace Properties. You can then cross reference this...
February 28, 2007 at 2:01 pm
You are correct as to the code that is causing the problem. If you are inserting/updating multiple rows, the trigger will fire once after the update, not once per row. ...
February 28, 2007 at 1:56 pm
You should be able to use the DBid column in Profiler to determine which database the stored procedure is comming from.
February 28, 2007 at 1:45 pm
What is the primary key on your table? Can you post your table DDL?
February 28, 2007 at 12:42 pm
Whoa, this is totaly different from what you've previously described. It would be very helpful if you would post your table DDL for both tables as well as sample data...
February 28, 2007 at 12:11 pm
Will all of the values have the same format of A10? If so, this will work:
DECLARE @table TABLE (value char(3))
DECLARE @table2 TABLE (id CHAR(1), code CHAR(2))
INSERT INTO @table
SELECT 'A10' UNION...
February 28, 2007 at 10:18 am
http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering.asp
If you search SSC for articles on Clustering, you'll find more.
February 28, 2007 at 9:59 am
Also, before changing your existing process, it may be worth finding out who or what is locking the file. Check the virus scanning software on the server. Make sure it...
February 26, 2007 at 8:21 am
I don't have a detailed example, but you could just use the text document destination connection object and push your data to a working file. Then follow that up with...
February 23, 2007 at 4:14 pm
Viewing 15 posts - 2,386 through 2,400 (of 3,232 total)