Viewing 15 posts - 5,356 through 5,370 (of 18,926 total)
ash0550 (6/16/2011)
case when BillOfMaterialsID <= 100 then 'Cheap'
When BillofMaterialsID between 101 and 500 then 'Medium'
When BillofMaterialsID between 501 and 1000 then 'HIGH'
When BillofMaterialsID between 1001 and...
June 16, 2011 at 3:38 pm
Ya but to pick only the used pages you must scan all pages (even if only the header). So that's an extra 200 - 900GB??? to extract from the...
June 16, 2011 at 3:16 pm
How does that reduce backup time?
And by how much?
June 16, 2011 at 2:18 pm
Ah! missed 1 little word in the post ;-).
June 16, 2011 at 1:40 pm
Tx for the script.. took only 30 seconds to do!
,RIGHT(REPLICATE('0', 5) + CONVERT(VARCHAR(10), ROW_NUMBER()over(Order by P.Vendor)+10) + '0', 5) AS [Document Item No]
June 16, 2011 at 1:13 pm
Think about it. The estimate plan runs with FMTONLY = ON.
If you don't execute the code, the table is not created and it can't be found while processing the...
June 16, 2011 at 1:09 pm
It could MAYBE be somewhat easy.
Read all the backups filelist into temp table
Restore with filelist
restore
Someone might knock this out in a couple hours at most.
June 16, 2011 at 12:58 pm
A little more annoying... but an indexed view could do the same trick as the filtered index with pretty much the same overhead.
June 16, 2011 at 12:56 pm
GSquared (6/16/2011)
mtillman-921105 (6/16/2011)
Steve Jones - SSC Editor (6/16/2011)
Fal (6/16/2011)
...
So I start undressing. As luck would have it...
June 16, 2011 at 12:39 pm
GSquared (6/16/2011)
Ninja's_RGR'us (6/16/2011)
Assuming 2K8...
Wouldn't it be possible to create a unique filtered index to...
June 16, 2011 at 12:34 pm
Are you on 2k5 or 2k8? I ask because poeple often post in the wrong forum.
Assuming 2K8...
Wouldn't it be possible to create a unique filtered index to avoid the...
June 16, 2011 at 12:26 pm
opc.three (6/16/2011)
Not trying to step in front of Gail...my shadow would maybe cover her pinky toe but the thread looked idle...SAVE TRANSACTION is when naming a transaction becomes relevant.
She's busy...
June 16, 2011 at 11:42 am
mya (6/16/2011)
Did you have a chance to look at my deadlock graphs?
Yup but Gail'S the expert so I'll let her answer this.
June 16, 2011 at 11:22 am
SQLRNNR (6/16/2011)
Ninja's_RGR'us (6/16/2011)
SQLRNNR (6/16/2011)
I have had similar happen to me - rebuild from scratch as Ninja said seems to work.The the default fix for most M$ products :hehe:.
Unfortunate, but rings...
June 16, 2011 at 10:24 am
Viewing 15 posts - 5,356 through 5,370 (of 18,926 total)