Viewing 15 posts - 31 through 45 (of 99 total)
Hi Grant-- thanks for the quick reply. (I think you meant "Unfortunately your tests are NOT quite fair")
Point taken regarding indexing. Let me ask a smaller question: The query plan...
February 17, 2011 at 1:08 pm
...what about a tie?
INSERT INTO #Runners SELECT 9,10,20
December 6, 2010 at 2:00 pm
My tlogs back up every 30 minutes at :00 and :30. Somehow my 2am TRN got deleted. As a result my 3:30am restore on another server failed when it tried...
November 8, 2010 at 2:34 pm
Steve Jones - SSC Editor (10/7/2010)
October 12, 2010 at 6:14 pm
Hi Sean,
I love the script! Did these get added?
...and for my little (very little) contribution, I would add an ISO date field (e.g., 20091006)
convert(varchar(10), getdate(), 112)
Why varchar(10) and not char(8)?...
July 21, 2010 at 5:59 pm
Ah I see how it works now! I was under the assumption that even if that Column existed in the FileInfo table and I was pulling from it that it...
July 15, 2010 at 2:58 pm
A little more fiddling and I've got the (one-line) fix:
Changed
CREATE EVENT NOTIFICATION notify_DdlDbEvents ON [highlight]DATABASE[/highlight] WITH fan_in FOR DDL_DATABASE_LEVEL_EVENTS TO SERVICE 'svcDdlDbEvents', 'current database';
To
CREATE EVENT NOTIFICATION notify_DdlDbEvents ON [highlight]SERVER[/highlight]...
June 29, 2010 at 5:24 pm
I quickly scanned the thread so I may be missing some details (and I've GOTTA get outta here) but you don't even really need to convert the 2 "seconds since...
May 20, 2010 at 7:48 pm
Phil Factor (3/31/2010)
Like Circular Saws, ORMs are great tools in the right hands, Like circular saws, the consequences of using them wrongly are difficult to put right.
In other words,...
March 31, 2010 at 2:17 pm
Jeff Moden (3/10/2010)
March 22, 2010 at 11:37 am
I may be misinterpreting your issue, but instead of using a "Notify Operator Task" use an "Execute TSQL Task" in your maintenance plan. The TSQL code to run would be...
March 11, 2010 at 3:39 pm
Paul White (3/2/2010)
mstjean (3/2/2010)
Are you saying it's possible for the following statement to insert non-sequential values for the identity:
INSERT INTO TableWithIdentity SELECT TOP 100 * FROM SomeTable
(YES...) Non-sequential/non-contiguous...The cause, by...
March 4, 2010 at 9:59 am
dialog, dualogue, diatribe,
dissention, declamation,
double talk, double talk
- Belew, Bruford, Fripp, Levin
March 2, 2010 at 1:27 pm
...uhoh...
Jeff Moden (3/1/2010)
...It would be diffcult to reserve a range of ID's with because IDENTITIES are not guaranteed to be sequential if other people are also inserting into the table.
Are...
March 2, 2010 at 10:45 am
Viewing 15 posts - 31 through 45 (of 99 total)