Viewing 15 posts - 76 through 90 (of 147 total)
[font="Verdana"]
chrisn-585491 (10/3/2011)
"It's hard to soar with the eagles at PASS, when you swim with the sewer rats in your current job." :crazy:
Love it !!! and same .... 😀 [/font]
October 4, 2011 at 12:17 am
GilaMonster (7/15/2011)
Rollbacks are complete. Other than table variables, I can't think of any DDL operations within a database that can't be rolled back
[font="Verdana"]Really helpful!
Thanks[/font]
July 15, 2011 at 6:29 am
GilaMonster (6/17/2011)
I used to run a major production server with that traceflag permanently enabled. It can't cause blocking (thing to block)
[font="Verdana"]Yes sure it doesn't cause blocking or in general performance...
June 17, 2011 at 1:42 am
passivebyz (5/27/2010)
Msg 102, Level 15, State 1, Procedure SP_GetBlockedInfo, Line 4
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Procedure SP_GetBlockedInfo, Line 25
Incorrect...
May 31, 2011 at 4:09 am
Grant Fritchey (5/26/2011)
Abrar Ahmad_ (5/26/2011)
Waiting ... ![/font]
I'm sorry, normally I let this stuff go, but, seriously, Waiting? I'm in here helping out because I want to be, not because you're...
May 29, 2011 at 9:36 pm
Grant Fritchey (5/26/2011)
May 26, 2011 at 5:37 am
Grant Fritchey (5/24/2011)
May 24, 2011 at 6:23 am
Grant Fritchey (5/24/2011)
Your approach is OK as mechanism to see what...
May 24, 2011 at 4:52 am
GilaMonster (5/23/2011)
Syed Jahanzaib Bin hassan (5/23/2011)
Use DTA for queries optimizations ...If you use DTA, do not simply accept its recommendations. Test them, implement the ones that make a difference.
[font="Verdana"]
Sorry, DTA?
Secondly...
May 24, 2011 at 1:29 am
notquitexena (11/17/2008)
...."DBCC FREESESSIONCACHE (Transact-SQL)
Flushes the distributed query connection cache used by distributed queries against an instance of Microsoft SQL Server......"
[font="Verdana"]
Please if you can explain that which buffers/caches are flushed in...
May 23, 2011 at 10:56 pm
Solomon Rutzky (5/1/2011)
Very thorough analysis. Great job!Take care,
Solomon...
[font="Verdana"]
But it seems at least a week long activity !!!
😛
Goodish!
[/font]
May 2, 2011 at 2:56 am
[font="Verdana"]Thank you Gila![/font]
April 25, 2011 at 4:44 am
GilaMonster (4/25/2011)
That's about all the general advice there is. If you want something specific, switch traceflag 1222 on. That will result in a...
April 25, 2011 at 3:23 am
Abrar Ahmad_ (4/11/2011)
Perry Whittle (4/11/2011)
That link covers VMWare Server which although very good is not a patch on it's big brother ESX server. The two are vastly different as ESX...
April 11, 2011 at 10:53 pm
Perry Whittle (4/11/2011)
Abrar Ahmad_ (4/11/2011)
[font="Verdana"]Some sign of relief @http://scottf.wordpress.com/2007/02/09/sql-server-on-vmware-server/
[/font]
That link covers VMWare Server which although very good is not a patch on it's big brother ESX server. The...
April 11, 2011 at 10:11 pm
Viewing 15 posts - 76 through 90 (of 147 total)