Viewing 15 posts - 6,166 through 6,180 (of 7,168 total)
:w00t: I'll add it to the list of things to try as a last resort when I see these issues come up...and they do come up regularly. Thanks for posting...
June 9, 2011 at 7:34 am
kurtyue (6/9/2011)
June 9, 2011 at 7:28 am
Leo.Miller (6/8/2011)
Change is Required (6/8/2011)
Can we access Secondary Server in Logshiiping or Can we mirror server in mirroring .?if yes explain
As has been mentione the answer to the first...
June 9, 2011 at 7:25 am
Jeff Moden (6/8/2011)
opc.three (6/8/2011)
Elliott Whitlow (6/7/2011)
On most of my systems I disable xp_cmdshell and don't allow its use..+1000
-1000 😉
Why all the FUD about xp_CmdShell? Done properly, it's an incredible...
June 9, 2011 at 7:18 am
Cool, I am always happy to lend a hand in the eradication of a cursor 🙂
Mine handles schemas now but I stopped short of (actually backed out of the...
June 8, 2011 at 8:05 pm
Lowell, we all agree they are acceptable for system maintenance however there is no need to use one here so I'm just as happy having one less cursor in the...
June 8, 2011 at 6:45 pm
James A. Lawrence (6/8/2011)
A_Pfxa_policyA_DATE_ADDEDA_PROCESSDATEA_NUM_PROCESSEDEndRReq CertPremaud AudDisp
GL69269509/15/200908/16/20090 ...
June 8, 2011 at 4:20 pm
You are on the right track. You can cascade CTEs as well. See of something like this works for you:
WITH StockSafety_CTE(ITEM, BU, Sub_Family_Desc, Sub_Family_Code, Current_ABC, CURRENT_ABC_WEEKS, Last_months_six_months_forecasts,...
June 8, 2011 at 4:01 pm
Change is Required (6/8/2011)
Can we access Secondary Server in Logshiiping?
To expound on what Suresh said, yes, you can, however when logs are applied no users can be connected to the...
June 8, 2011 at 3:37 pm
Depending on your requirements regarding tracking historical changes to the data either Change Data Capture or Change Tracking could be a good fit. Both are configurable at the table-level.
June 8, 2011 at 2:53 pm
Jnrstevej (6/8/2011)
June 8, 2011 at 2:29 pm
Awesome, thanks. This code demonstrates how you can create the Current_Stock column.
WITH StockSafety_CTE(ITEM, BU, Sub_Family_Desc, Sub_Family_Code, Current_ABC, CURRENT_ABC_WEEKS, Last_months_six_months_forecasts, Standard_Cost, A, B, C, D, E, Current_ABC1, Current_six_months_Forecast,...
June 8, 2011 at 1:52 pm
Sure, could you kindly post DDL for your tables and DML to add your test data? If you're not sure what I mean please refer to this article:
http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D
June 8, 2011 at 12:48 pm
Viewing 15 posts - 6,166 through 6,180 (of 7,168 total)