Viewing 15 posts - 16 through 30 (of 94 total)
michaelrounds (4/15/2013)
There are a few other fixes in this update as well. All the gen_Get* stored...
April 15, 2013 at 5:04 pm
HealthReport Job Failed - overflow converting to int.
Not sure which of these in the "d" set is the offender - changed them all to bigint for belts and braces:
UPDATE c
SET...
April 15, 2013 at 4:40 pm
Small enhancement requests re Jobs:
1. If a Job is disabled, don't color the success/failed Last Outcome cell.
2. If a job hasn't been executed in the last MONTH, ignore the status,...
April 15, 2013 at 3:39 pm
On the subject of the database name: rather than have to individually edit about 140 occurrences of DBA to <db-name-of-our-choice>, would you consider using the SSMS Template-style <Database_Name, sysname, Database_Name>...
April 15, 2013 at 11:55 am
michaelrounds (4/12/2013)
SAinCA (4/12/2013)
Is there reason why you use 3-part naming immediately after the MANY "Use [dba]"...
April 12, 2013 at 5:42 pm
michaelrounds (4/12/2013)
SAinCA (4/12/2013)
Is there a way you could incorporate monitoring of additional SQL-oriented services? We had an issue with Red Gate's SQL Backup Service ceasing when the...
April 12, 2013 at 5:38 pm
Yet more "Thanks!"
Is there a way you could incorporate monitoring of additional SQL-oriented services? We had an issue with Red Gate's SQL Backup Service ceasing when the SQL Service...
April 12, 2013 at 3:24 pm
Thanks for clarifying.
My "normal" is to always use READ_SNAPSHOT_ISOLATION for every SQL2005 or later User DB so I can nuke WITH (NOLOCK) from legacy code.
Guess I normally expect...
March 6, 2013 at 2:11 pm
Not sure if what you are saying is that "it didn't happen the way I said it did..."
READ_COMMITTED_SNAPSHOT isolation is set ON for the database in question.
In order...
March 6, 2013 at 1:53 pm
Please, if you're on SQL2005, watch out that you have sufficient TEMPDB space to accommodate all those deleted rows.
When a row is deleted, it is stored in TEMPDB as, forgive...
March 6, 2013 at 11:31 am
I use the RSS feed for the Most Recently Modified updates.
The quantity of updates is large - I have over 300 unread in five days. At that rate it's...
March 4, 2013 at 11:39 am
Cade Roux (1/13/2013)
Any particular reason that sp_getapplock wasn't used for this implementation?
Thanks for pointing this out... My predecessor used a data update of all rows with a...
January 14, 2013 at 12:00 pm
SQL2012EE on Win2K8R2 active-passive 128GB RAM single 6-core E5-2640 @ 2.5 GHz on Dell R720 runs at:
- Transaction/sec: 13800 peak, 1600 average excluding peaks.
- 1170 Batches/sec peak, otherwise between 100...
December 21, 2012 at 10:58 am
Thanks for remembering! I'll insert a comment "Note to self: ..." in the code to revisit that!
I'll be a bit delayed as the current server is Win2003 and I...
December 5, 2012 at 2:07 pm
I pointed SQL Prompt at it immediately I saw the mess the copy-paste left behind. Didn't attribute you with sloppy indentation 😀
December 4, 2012 at 1:36 pm
Viewing 15 posts - 16 through 30 (of 94 total)