Viewing 15 posts - 61 through 75 (of 1,583 total)
Did you ever get this working?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 17, 2015 at 1:18 pm
I typically made the following changes:
1. Change the file growth settings from percentages to fixed growths of 512MB (or 1GB depending on what the server is used for - and...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 4, 2015 at 6:08 am
Both good recommendations, I really appreciate it!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 7, 2015 at 12:30 pm
Have you found anything online about this waittype? I have a new server that's showing this as the highest waittype
PatternSample EndedSeconds Samplewait_typeWait Time (Seconds)Signal Wait Time (Seconds)Percent Signal WaitsNumber...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 28, 2015 at 5:55 pm
Hilarious responses today - Some people need to have a drink and relax a little :w00t:
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 24, 2015 at 12:01 pm
similar to what was already suggested, you can start by comparing the results of
SELECT * from sys.configurations order by NAME
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 25, 2015 at 9:57 am
+1 to the rest of the comments; but there could be many reason for the timeout errors. Clearly indexes/statistics can cause performance issues....and since you changed a column data...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 25, 2015 at 9:54 am
It's possible but I haven't found any instances of that (I scrutinize heavily for those types of performance killers) 😀
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 25, 2015 at 9:18 am
Steve Jones - SSC Editor (6/23/2015)
Q2: doesn't make sense. What do you mean by avoid...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 23, 2015 at 12:58 pm
A few things:
Opinion: Your fragmentation level check is set way too low (5% - consider changing this to 10% or 15% as that really isn't a lot of fragmentation unless...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 20, 2015 at 8:28 am
I'm puzzled by this "with backup device creating backups with a new transaction log for each day"
How is it possible that it's creating a new physical transaction log file daily?...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 20, 2015 at 8:10 am
comeraghsolutions (6/5/2015)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 5, 2015 at 9:42 am
Are you attempting to start the service via the SQL Server Configuration Manager? If so, try doing it from the services applet in the control panel and see if it...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 5, 2015 at 8:15 am
A permissions problem would most likely result in an error, the fact that the user doesn't get an error and just receives a blank screen leads me to believe that...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 5, 2015 at 7:53 am
It was in the link I added in my OP CREATE FUNCTION [dbo].[fx_DelimitedSplit8K]
--===== Define I/O parameters
(@pString VARCHAR(8000), @pDelimiter CHAR(1))
RETURNS TABLE WITH SCHEMABINDING...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 3, 2015 at 12:51 pm
Viewing 15 posts - 61 through 75 (of 1,583 total)