Viewing 15 posts - 46 through 60 (of 120 total)
pooyan_pdm (8/9/2012)
run select * from sys.databases and check log_reuse_wait_descyou might have an active transaction to check that you can use dbcc opentran('DBName')
I did that and it came back with...
August 9, 2012 at 12:31 pm
Haha, that was it exactly! Too early in the morning for that 😉 And my formatting was backwards. Thanks!
April 19, 2012 at 7:07 am
Alexander Suprun (3/13/2012)
March 13, 2012 at 7:49 pm
I figured out that it was actually being caused by indexing.
On the old server, there were several of the tables that were heaps with non-clustered indexes. I...
March 13, 2012 at 6:35 pm
rafael lenartowicz (3/11/2012)
I'd start...
March 12, 2012 at 6:15 am
Here is the current execution plan
March 11, 2012 at 2:37 pm
Aneesh Soman (3/8/2012)
Please add more info about the particular query.
SELECT mbm1.BMWHS
,mbm1.BPROD AS BPROD_L1
,iimx.IPROD AS BCHLD
,iimx.IDESC
,iimx.IITYP
,iimx.IUMS
,(cmf.Ingredients+cmf.Packaging) AS COST
,((ISNULL(mbm1.BQREQ,1))/ISNULL(cic1.ICBTCH,1))
*((ISNULL(mbm2.BQREQ,1))/ISNULL(cic2.ICBTCH,1))
*((ISNULL(mbm3.BQREQ,1))/ISNULL(cic3.ICBTCH,1))
*((ISNULL(mbm4.BQREQ,1))/ISNULL(cic4.ICBTCH,1))
*((ISNULL(mbm5.BQREQ,1))/ISNULL(cic5.ICBTCH,1))
*((ISNULL(mbm6.BQREQ,1))/ISNULL(cic6.ICBTCH,1))
AS QTYREQ_NOSCRAP
,((ISNULL(mbm1.BQREQ,1)*ISNULL(mbm1.BMSCP,1))/ISNULL(cic1.ICBTCH,1))
*((ISNULL(mbm2.BQREQ,1)*ISNULL(mbm2.BMSCP,1))/ISNULL(cic2.ICBTCH,1))
...
March 8, 2012 at 1:17 pm
Thanks. I understand the concepts when you know the data but what if you don't know the data? Is there a quick script that will show each columns...
December 19, 2011 at 1:34 pm
Thank you, I will take a look!
November 10, 2011 at 4:17 pm
So what we ended up doing was to stop the services and start in single user mode and add the new accounts.
September 3, 2011 at 11:42 am
Go to the linked server properties, the security tab. There is a radio button below that says for logins not in the list, what do you do? If you check,...
August 10, 2011 at 7:24 am
Steve Jones - SSC Editor (8/9/2011)
August 9, 2011 at 9:54 am
So you can put an Oracle login in the "Remote User" field? When I try it gives me an "invalid user/pass" error, even though it works if I just...
August 9, 2011 at 9:01 am
Jeffrey Williams-493691 (5/31/2011)
This should get you started: http://technet.microsoft.com/en-us/library/cc709691(WS.10).aspx
That worked, thanks!
May 31, 2011 at 4:35 pm
Jeffrey Williams-493691 (5/31/2011)
May 31, 2011 at 1:40 pm
Viewing 15 posts - 46 through 60 (of 120 total)