Viewing 15 posts - 5,431 through 5,445 (of 18,926 total)
Trey Staker (6/15/2011)
Trey Staker (6/15/2011)
SQLRNNR (6/15/2011)
Ninja's_RGR'us (6/15/2011)
Steve Jones - SSC Editor (6/15/2011)
Brandie Tarvin (6/15/2011)
SQLRNNR (6/15/2011)
Brandie Tarvin (6/15/2011)
I think y'all are just adding posts to get extra points!:w00t:
Whut? No way....
June 15, 2011 at 10:56 am
Trey Staker (6/15/2011)
SQLRNNR (6/15/2011)
Ninja's_RGR'us (6/15/2011)
Steve Jones - SSC Editor (6/15/2011)
Brandie Tarvin (6/15/2011)
SQLRNNR (6/15/2011)
Brandie Tarvin (6/15/2011)
I think y'all are just adding posts to get extra points!:w00t:
Whut? No way. Not...
June 15, 2011 at 10:50 am
Just throwing another idea out there.
Fire up profiler, filter on your login / username.
Trace stmt complement in batch or proc depending on how you are executing the code
Fire up the...
June 15, 2011 at 10:48 am
<RelOp NodeId="0" PhysicalOp="Top" LogicalOp="Top" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="33"
EstimatedTotalSubtreeCost="3.28441"
June 15, 2011 at 10:06 am
Script the trace in a proc and then :
http://weblogs.sqlteam.com/mladenp/archive/2007/08/14/60280.aspx
June 15, 2011 at 10:04 am
Steve Jones - SSC Editor (6/15/2011)
Brandie Tarvin (6/15/2011)
SQLRNNR (6/15/2011)
Brandie Tarvin (6/15/2011)
I think y'all are just adding posts to get extra points!:w00t:
Whut? No way. Not possible.
Yes way.
For example:...
June 15, 2011 at 10:01 am
TheSQLGuru (6/15/2011)
2) sharepoint is HORRIBLE from a database perspective! there are quite a few indexes that need...
June 15, 2011 at 8:59 am
There's not much we can offer here. Find a way to see what line of code is not compiling (SET FMTONLY ON might help).
Once you see that correct it...
June 15, 2011 at 8:06 am
Grant Fritchey (6/15/2011)
That's 10,000 posts, done.Wait, now it's 10,001.
Welcome to the club!!! 😀
June 15, 2011 at 6:12 am
srivathsani-296624 (6/15/2011)
The backup compression is a great feature in SQL Server 2008.But since the backup of the database is in compressed state,it takes a longer time for the database to...
June 15, 2011 at 2:47 am
waynejohn (6/14/2011)
Hmm...this is an old one...and still no response from anyone. Matches my issue perfectly....no banana. :ermm:
Go in master, open up the sp in question. Copy the...
June 14, 2011 at 11:43 am
So since you're on the careful side you'd use 75 GB?
Now how hard was it to provide that info upfront :hehe:??????
June 14, 2011 at 6:37 am
Grant Fritchey (6/14/2011)
June 14, 2011 at 6:14 am
Yes enable snapshot isolation.
The only to find out the cost is to test. Assuming the server is not near is max output you "should" be fine. Can't know...
June 14, 2011 at 5:54 am
Viewing 15 posts - 5,431 through 5,445 (of 18,926 total)