Viewing 15 posts - 20,521 through 20,535 (of 22,196 total)
Just run "File", "Export", "Script Trace Definition", "SQL Server 2005" and you can define the file from there. Attach it to a message (cause posting it would be ugly).
April 29, 2008 at 1:03 pm
Wild.
That's sure a surprise that you shouldn't run trace in production... Since I've got it running off & on on most production servers and I have yet to see...
April 29, 2008 at 12:51 pm
We carried straight jackets... That's all I'm going to say about that.
April 29, 2008 at 11:23 am
Short answer: it depends.
Slight longer answer: When looking at a system like this, you have to decide, is it a single integrated system or a series of apps that have...
April 29, 2008 at 11:22 am
OK.
Then without details... I think the insert & update is better.
April 29, 2008 at 10:32 am
I agree. You should minimize what is maintained there to only what is needed to run the processes that move the data in & out. Assuming it's not also used...
April 29, 2008 at 9:28 am
He's right. With very, very few exceptions, every table should have a clustered index. Further, every table should have a primary key and that constraint can be clustered (since it...
April 29, 2008 at 9:25 am
Kevin Durham (4/29/2008)
April 29, 2008 at 9:23 am
codevault33 (4/29/2008)
April 29, 2008 at 9:17 am
No, it's an implicit commit. I just got the same results. I ran this query against Adventureworks:
SELECT soh.[SalesOrderID]
,sod.[SalesOrderDetailID]
FROM Sales.[SalesOrderHeader]...
April 29, 2008 at 9:12 am
It is a small world. I was on SSN606, Tinosa (a pile of glowing razor blades now). I was nuclear power machinist mate. In other words I used a slightly...
April 29, 2008 at 8:52 am
It sure beats working on a nuclear powered submarine in terms of pay, benefits, hours, cleanliness... Yeah, I'd say it's still a good career.
April 29, 2008 at 6:47 am
I'd have to see the procedure to understand why you're getting a difference. But I think, and I could be wrong about this, the batch includes the commit, but the...
April 29, 2008 at 6:45 am
To give you a specific answer you need to post specific information, the two tables & some sample data. See here: http://www.sqlservercentral.com/articles/Best+Practices/61537/
In general, you shouldn't have to do cursors or...
April 29, 2008 at 6:05 am
Viewing 15 posts - 20,521 through 20,535 (of 22,196 total)