Viewing 15 posts - 48,271 through 48,285 (of 49,552 total)
Not unless there's some trigger on those tables that audits changes.
You can run profiler against the server to see what commands and procedures are run by the app. DEpending whether...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2007 at 12:56 am
xintanaka (10/31/2007)
DECLARE @TranName VARCHAR(20)SELECT @TranName = 'MyTransaction'
BEGIN TRANSACTION @TranName
p.s. I wouldn't bother getting into the habit of naming your transactions. Transaction naming is more for commenting than anything else and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2007 at 12:40 am
By bulk operation, I'm resfering to a specific T-SQL command - BULK INSERT. Normal inserts, updates, deletes are not bulk operations, and they log completely to the tran log, as...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2007 at 12:11 am
For the option I suggested, you need a table (call it RequestedJobs). This is just a very rough example, and may need tweaking/enhancing for your environment.
CREATE TABLE RequestedJobs (
RequestTime DATETIME,
Request...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 31, 2007 at 7:27 am
A few years back I was working as a developer in a custom software house. One week we came up with a prank to play on some of out more...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 31, 2007 at 5:20 am
The 'default' length of varchar depends on where it is used.
In management studio, when creating a table the default length is 50.
If you declare a variable of type varchar...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 31, 2007 at 1:53 am
The problem is in the lines
SELECT TOP 1 @Dobjectkey = object_key FROM DELETED
SELECT TOP 1 @Iobjectkey = object_key FROM INSERTED
There can be multiple lines in the inserted and deleted...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 31, 2007 at 1:13 am
aspersage (10/30/2007)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 31, 2007 at 1:00 am
Two options.
1 - Have the trigger insert a row into a RequestedJobs table, and reset the status. Create a SQL Agent job that polls the table at enatever frequency is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 31, 2007 at 12:50 am
dandrade (10/30/2007)
I saw this QotD where the answer was TRUNCATE TABLE. Then I read a bit more and was amazed that there is no writing to the Log:
Truncate does write...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 31, 2007 at 12:20 am
p.s. If you don't have space in the DB, you can also BCP the data that you want to keep out to a network drive/removeable drive, then BCP in once...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 31, 2007 at 12:15 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 31, 2007 at 12:12 am
Ben Sullins (10/30/2007)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 30, 2007 at 11:58 pm
Just watch out for the simulations. They catch a lot of people.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 30, 2007 at 5:55 am
Viewing 15 posts - 48,271 through 48,285 (of 49,552 total)