Viewing 15 posts - 8,056 through 8,070 (of 49,571 total)
curious_sqldba (8/19/2014)
Reason I say that is if I have multiple file groups I can just backup that one file group and restore on Dev server for troubleshooting purposes.
No, you...
August 19, 2014 at 7:44 am
Ok..... I'll mark that one down as another tool to avoid.
p.s. If you don't keep the log backups, then you can't restore to point in time. In that case, assuming...
August 19, 2014 at 3:48 am
protix (8/18/2014)
Well, I'm interested in the performance mainly.
How many transactions/sec are you talking here? What hardware? What are your current bottlenecks?
August 19, 2014 at 3:47 am
TheSQLGuru (8/18/2014)
August 19, 2014 at 2:33 am
If you want it urgently, then make it as easy as possible for someone to answer.
Please provide the CREATE TABLE for all involved tables and the sample data as insert...
August 19, 2014 at 2:30 am
RPSql (8/18/2014)
I was looking for a general practice you follow in order to set MAXDOP setting on a SQL instance.
0 unless I have a good reason to change it.
August 19, 2014 at 2:29 am
MyDoggieJessie (8/18/2014)
TheSQLGuru (8/18/2014)Don't forget the other part of the equation - Cost Threshold for Parallelism. The default of 5 is universally too low.
What's a good way to...
August 19, 2014 at 2:28 am
codykonior (8/18/2014)
He thinks, this will clear out log records,...
August 19, 2014 at 2:24 am
Firstly, is that value a problem? Is it higher than usual? Is it causing problems?
August 19, 2014 at 2:23 am
Luis Cazares (8/18/2014)
DELETE MySchema.Facttable
WHERE datecol = @Date;
It's part of...
August 19, 2014 at 2:18 am
Do it the other way around. Look at the queries, look at how they filter, whether there's a common predicate (like WHERE Archived = 0), which is not parameterised. That...
August 18, 2014 at 11:35 am
No where near enough info. That error message is useless
Try taking a backup from a query window (backup database ... to disk = '<backup location>') and post any and all...
August 18, 2014 at 7:24 am
Sindhu Ravi (8/18/2014)
August 18, 2014 at 6:24 am
I can't see your screen, I haven't read your requirements, I can't read your mind 🙂
If you had no knowledge of this problem and someone told you just what is...
August 18, 2014 at 6:22 am
SQL Galaxy (8/18/2014)
I am not sure those counter normal values, It might be < 500 seconds for better (soft/hard...
August 18, 2014 at 6:19 am
Viewing 15 posts - 8,056 through 8,070 (of 49,571 total)