Viewing 15 posts - 5,386 through 5,400 (of 22,227 total)
But PLE is not a measure of performance. It's merely an indication of load and behavior. Having low or wildly variable PLE is not, by itself an indication of a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 18, 2015 at 6:56 am
GilaMonster (11/17/2015)
You could buy a tool like Red Gate's SQLCompare and SQL DataCompare to sync the data and schema, but it's probably...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 18, 2015 at 6:54 am
The up and coming technology for HA these days is Availability Groups. There are lots of good articles available at Simple-Talk.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 18, 2015 at 6:47 am
I agree with Gail. I just didn't want to be too negative. If you have the MDF file, you can at least attempt an ATTACH. The likelihood is, everything is...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 17, 2015 at 6:08 pm
silas.perkins (11/17/2015)
Asking for expert opinion. A very unfortunate event happened. One of our PCs crashed few days ago. That PC had SQL Server 2008 installed. Unfortunately no backup was running...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 17, 2015 at 10:25 am
WayneS (11/16/2015)
Lynn Pettis (11/13/2015)
(think government contracted software development).
My scary story when working with the gov't.
Software contract awarded, specified that all data access has to go through stored procedures.
They sent to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 17, 2015 at 8:40 am
jasona.work (11/12/2015)
BrainDonor (11/12/2015)
My Grandmother had an expression, when she thought somebody was being really lazy - "Sit down and I'll walk around for you" - http://www.sqlservercentral.com/Forums/Topic1735905-392-1.aspx#bm1735907
I just glanced at the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 12, 2015 at 6:32 am
If you're on 2012, the GUI is really easy. Don't use the Wizard. It's a waste of time and more than a little misleading.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 12, 2015 at 4:44 am
You're posting in the 2008 forum with a 2005 question.
If you were in 2008 I could tell you to look at the system_health extended event session which captures deadlock information....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 12, 2015 at 4:41 am
No.
Differentials are like Full backups. You restore the backup using the STOPAT, then you can use logs to get to 5PM. If you use the differential, I think it'll error...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 12, 2015 at 4:38 am
Alan.B (11/11/2015)
sgrimard (11/11/2015)
Any suggestion on good books or site to learn how to create good index?
SQL Server 2012 Query Performance Tuning (Expert's Voice in SQL Server) by Grant Fritchey is...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 12, 2015 at 4:30 am
BL0B_EATER (11/12/2015)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 12, 2015 at 4:25 am
The variable is not able to be sampled by the optimizer, so it generates an estimate from the statistics instead of using a specific value. When you pass a specific...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 11, 2015 at 8:03 am
samot-dwarf (11/11/2015)
Just steer clear of multi-statement table valued functions, and everything will be OK.
Maybe your devs want to replace RedGateMonitor.[utils].[SplitString] with something as at http://www.sqlservercentral.com/articles/Tally+Table/72993/ :hehe:
We have a winner!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 11, 2015 at 4:21 am
Steve Jones - SSC Editor (11/10/2015)
jasona.work (11/10/2015)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 10, 2015 at 12:39 pm
Viewing 15 posts - 5,386 through 5,400 (of 22,227 total)