Viewing 15 posts - 48,301 through 48,315 (of 49,571 total)
How many rows are you keeping relative to the number you're deleting?
What I often suggest for deletes that affect most of the table is to first copy the rows you...
October 31, 2007 at 12:12 am
Ben Sullins (10/30/2007)
October 30, 2007 at 11:58 pm
Just watch out for the simulations. They catch a lot of people.
October 30, 2007 at 6:05 am
If the MS exam security people notice you offering brain dump links, there's a good chance that you will have any certifications you have revoked and a ban placed on...
October 30, 2007 at 5:55 am
See the link in the menu mar (to the left) 'Write for us'? Everything you need is there.
October 30, 2007 at 5:50 am
In that specific example, sure, but not necessarily for triggers in general. Depends what you're trying to do with them. They have their place.
But back to your problem. My gut...
October 30, 2007 at 4:31 am
Peter Gadsby (10/30/2007)
If a trigger is executed on insert then every row that is inserted into the table will trigger the trigger, this will drastically reduce performance.
Sergiy's point is that...
October 30, 2007 at 3:30 am
I think all the installer does is drop the files in SQL's data directory. Assuming default installation, you'll find them in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
Go to management studio and attach...
October 30, 2007 at 2:17 am
No. you're checking for an error directly after the update statement, and if there is an error, you're rolling the entire transaction back (everything back to the begin tran)
p.s. Since...
October 30, 2007 at 2:08 am
I could be mistaken, but is that the default trace you're trying to delete?
If so, change the server's property to prevent it from starting. I don't think you can close...
October 30, 2007 at 1:31 am
Sandy (10/29/2007)
Hey Gail,I apology for that...:D
I didn't mean that.(he he he..lolz)
Is fine. I was fairly sure you didn't 😉
Actually Grant is one of my Fav member in this site.
Oooh, Grant,...
October 29, 2007 at 6:25 am
Common Table Expressions, despite their name, are not tables. Think of them as a temporary view that you can use to simplify a query. The 'temporary view' lasts for just...
October 29, 2007 at 6:02 am
Peter Gadsby (10/29/2007)
Update process1. Drop indexes on another TRANSFORM table
2. Create new indexes on other TRANSFORM Table
3. Add indexes on TRANSFORM_TABLE
4. Perform a number of updates from other TRANSFORM table.
I'm...
October 29, 2007 at 4:38 am
Peter, can you describe the ETL process, step by step, along with the durations and aprox data rows affected for each step. Without some idea what's happening, we're shooting in...
October 29, 2007 at 3:58 am
Viewing 15 posts - 48,301 through 48,315 (of 49,571 total)