Viewing 15 posts - 1,021 through 1,035 (of 1,583 total)
How often are your Transaction Log backups running?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 6, 2012 at 1:23 pm
LOL, true...been a very busy day here at the office 🙁
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 6, 2012 at 1:04 pm
Scott D. Jacobson (8/6/2012)
Maybe I'm missing something here but how does knowing which index is the largest help with the contention created by the contradictory autogrow settings?
It doesn't. But...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 6, 2012 at 12:10 pm
Okay, so your larger index is about 45GB (math could be wrong on that but I think that's right)
Is the DB in simple or full mode?
Recommended changes: Remove the restricted...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 6, 2012 at 11:53 am
Something like this (you need to run per DB)
SELECT
i.name ...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 6, 2012 at 11:12 am
What options are you using in your INDEX scripts?
If your initial file size is 94.6GB and you have the autogrowth increments set to 500MB...and you have the file size capped...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 6, 2012 at 9:40 am
It's an integration services control "- Slowly Changing Dimension"
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 6, 2012 at 9:33 am
SSIS - SQL Server Integration Services (similar to DTS in SQL versions prior to 2005)
BCP - Bulk Copy Program (http://msdn.microsoft.com/en-us/library/ms162802.aspx)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 6, 2012 at 9:14 am
@suresh - fixing the row at the subscriber would be your easiest method
If you find you must take a new snapshot of the article, make certain you disable the immediate...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 6, 2012 at 7:53 am
guerillaunit (8/6/2012)
Is there a way to find out what jobs are using a certain stored procedure?
Are you wanting to see only SQL Agent Jobs or as damodharan has already provided,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 6, 2012 at 7:44 am
What have you tried so far? Please post your code...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 5, 2012 at 4:08 pm
(1)-add code to save current data to a set tables (archive) before importing, if user decides to roll back, this set of archive tables set can be used for rollback...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 5, 2012 at 10:39 am
Wow, I really thought this post would have generated dozens of replies by now! Must be Friday 🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 3, 2012 at 9:00 am
The OP says Windows Authentication is OK, it's when they log in with a SQL Server account that they get the error...this has no bearing on AD
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 3, 2012 at 6:27 am
Any luck?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 2, 2012 at 9:58 pm
Viewing 15 posts - 1,021 through 1,035 (of 1,583 total)