Viewing 15 posts - 1,471 through 1,485 (of 1,583 total)
Sorry I didn't clarify a few things that obviously were important, so let me clarify 4 those things:
1) I dropped all non-clustered indexes but kept the clustered (which I just...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 19, 2011 at 9:20 pm
Got this working. A colleague forwarded me this article (http://www.dwdmbi.com/2010/12/use-updlock-readpast-table-hints-to.html) which made an interesting note about a needed index in order to avoid SQL parsing through the entire table...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 18, 2011 at 1:22 pm
Thanks for the suggestions...will try them out shortly.
I wanted to clarify this though, wouldn't:
SELECT TOP 1 (...) FROM Reports WITH(UPDLOCK, READPAST) or (ROWLOCK,READPAST)
lock the row from the Reports table...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 17, 2011 at 2:44 pm
Thanks for the input guys, I've asked our Tech Services department to investigate the issue further.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 16, 2011 at 12:45 pm
@Dixie
Absolutely! Some great pubs here in Nashville!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 13, 2011 at 10:37 am
No worries Jeff. I value your comments and a lot of times look to see your answers on others posts because you've always got something good to say! ...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 13, 2011 at 10:12 am
Jeff, see the very first post
This was the code that I originally posted. Pretty simplistic. Later when you requested me not to paraphrase anything (which I don't get...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 13, 2011 at 9:07 am
Good God Jeff. Of course there's TRY...CATCH blocks all over the code above. After all. THATS what I originally posted. There's no conspiracy here. And yes,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 13, 2011 at 1:00 am
Actual code (really not much different that already posted regards what I'm trying to accomplish but here it is:
DECLARE @Cnt int
DECLARE @job_id uniqueidentifier
DECLARE @job_1 varchar(100), @job_2 varchar(100), @job_3 varchar(100),...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 12, 2011 at 1:35 pm
Appreciate the input guys (sincerely) and it's immensely VALUED but this still doesn't resolve the error at hand:
Msg 22022, Level 16, State 1, Line 0
SQLServerAgent Error: Request to run job...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 12, 2011 at 12:57 pm
It would all seem to be a matter of "timing". Yes I did set a delay (1 hour) but I guess I didn't wait enough...when I checked it again...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 4, 2011 at 9:56 pm
Thanks for the post! To clarify: I know how to restore a DB in either state :), my muddled question was if anyone knew why it might not be...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 4, 2011 at 7:43 am
Try Ninja's suggestion and run it against the linked server itself, and you can also try it using OPENQUERY
For instance:
SELECT
DISTINCT pt.ptno,t.suspense
FROM OPENQUERY(lnksvr1, '
SELECT pt.ptno,t.suspense
FROM
db1.dbo.Table1 pt
INNER JOIN db1.dbo.[271_Ineligible]...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 26, 2011 at 12:22 pm
Try this link 😎
It's helpful for what you are needing and will provide a little humor for the day!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 25, 2011 at 11:10 am
Well, you can create a series of alerts (Under SQL Server Agent >> Alerts) - SQL2005 has a pretty wide range of alerts for DB file growth/% used and such...
Example...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 25, 2011 at 10:53 am
Viewing 15 posts - 1,471 through 1,485 (of 1,583 total)