Viewing 15 posts - 991 through 1,005 (of 1,583 total)
Anyone want to take a stab at this? 😉
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 8, 2012 at 6:10 pm
So now that we're all on board again 🙂 The OP is asking "why" they are seeing this growth and reclaiming of space...?
"We rebuilt all the indexes on this...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 8, 2012 at 5:58 pm
OH GOD I am sorry for that misleading statement (clearly not enough coffee this morning when I wrote that). No, NCI's are not affected by the rebuild of a...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 8, 2012 at 1:45 pm
How many rows are in this heavily used table? 4% fragmentation really shouldn't be a big deal unless you've got millions of rows in the table and are adding/removing...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 8, 2012 at 10:22 am
Yes it is supposed to be []
INSERT INTO [NAS2-RPS].CORELIBRARY_ARCHIVE.dbo.MessengerLog (SequenceNumber, MessengerPrimaryKey, MessengerTableName, MessengerOperationType)
SELECT SequenceNumber, MessengerPrimaryKey, MessengerTableName, MessengerOperationType
FROM CORELIBRARY_STAGING.dbo.MessengerLog
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 27, 2012 at 2:22 pm
So why is it possible that I can compile a procedure on Server A with a 4-part naming with no issues
But on Server B, I get that error?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 27, 2012 at 1:58 pm
@opc.three - tried that. Again I can execute it but the code won't compile. Executes successfully, gives the above error when hitting the parse or compile buttons.
@matt-2. ...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 27, 2012 at 1:10 pm
Make sure that your proxy account has access to the location that you are attempting to delete the files. When you use xp_ functions, it uses the proxy account...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 29, 2012 at 6:05 am
I think you should add in the query_plan field from the dm_exec_query_plan DMV so you have a clickable link that will open up the actual execution plan for each top...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 10, 2012 at 1:19 pm
I think the problem was that fileNotify.fileexists is not a bit type. This should work:
Whoooooops! :w00t: When I test it with a temp table I used a bit...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 10, 2012 at 12:46 pm
How many steps are in your job?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 10, 2012 at 12:14 pm
No sweat, let me know and good luck!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 10, 2012 at 10:58 am
The easiest way i can think of is to use the RAISERROR - Try something like this:
DECLARE @Result bit
SET @Result = (
SELECT DISTINCT
fileexists
FROM fileNotify
WHERE fileexists = 'false'
)
IF (@Result =...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 10, 2012 at 9:48 am
@Lowell +1
(makes sense considering it used to work, but recently stopped)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 10, 2012 at 9:24 am
Is this a new mail server that you've set up or is it one that used to work now all of a sudden doesn't work?
If it's a new one you've...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 10, 2012 at 7:27 am
Viewing 15 posts - 991 through 1,005 (of 1,583 total)