Viewing 15 posts - 25,876 through 25,890 (of 49,552 total)
No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1116746-149-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 29, 2011 at 3:41 am
Jeff Moden (5/28/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 29, 2011 at 3:39 am
A copy_only backup isn't going to speed anything up. It's a backup that simply doesn't change the differential base, nothing more.
http://sqlinthewild.co.za/index.php/2011/03/08/full-backups-the-log-chain-and-the-copy_only-option/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2011 at 11:28 am
Syed Jahanzaib Bin hassan (5/28/2011)
MAXDOP purpose is because of HASH aggregate in the execution plan as he mentioned ,it will reduce cost of Hash Aggregate,Try to achieve Stream Aggregate
No it...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2011 at 7:37 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1116627-338-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2011 at 4:15 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2011 at 3:21 am
It makes absolutely no difference here whether the include column is encrypted or not. What you have there is a straightforward select with a SARGable predicate against a covering index....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2011 at 3:20 am
Jim Murphy (5/27/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2011 at 3:15 am
Grant Fritchey (5/27/2011)
Roy Ernest (5/27/2011)
WayneS (5/27/2011)
GilaMonster (5/27/2011)
Precon and spotlight! Could this PASS Summit get any better?So, you're aiming for a keynote address now?
Along with Dr DeWitte
She'll probably start correcting him.
Hot...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2011 at 3:34 pm
Precon and spotlight! Could this PASS Summit get any better?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2011 at 1:44 pm
GSquared (5/27/2011)
jcrawf02 (5/27/2011)
GSquared (5/27/2011)
Gianluca Sartori (5/26/2011)
jcrawf02 (5/26/2011)
Gianluca Sartori (5/26/2011)
jcrawf02 (5/26/2011)
Wow, you thought that there were too many other DBAs that were better suited than Brandie? That's not very nice...😛
Funny, but...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2011 at 8:48 am
Lucky9 (5/26/2011)
Reason i have posted again because i did not get help with the previous post...
You call over 10 replies 'No help'? Really?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2011 at 8:08 am
In general it's more efficient to query for just the rows you want.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2011 at 7:06 am
Backup database or backup log?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2011 at 7:05 am
BCP is an executable, it's run from the OS command prompt, not from SSMS.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2011 at 6:22 am
Viewing 15 posts - 25,876 through 25,890 (of 49,552 total)