Viewing 15 posts - 1,096 through 1,110 (of 2,008 total)
qur7 (12/5/2011)
what do you mean by make sure the chains are not broken...since this is a automated process.. do i have to enable job in a specific order?
thanks in advance.
Yes....
December 5, 2011 at 8:15 am
ROBUST PLAN
Forces the query optimizer to try a plan that works for the maximum potential row size, possibly at the expense of performance. When the query is processed, intermediate...
December 5, 2011 at 8:08 am
crookj (12/5/2011)
WOTD - Frigid8 Degrees at this time.... with wind chill at -15.....
Ice Cream... Yummmmy
December 5, 2011 at 8:03 am
Gianluca Sartori (12/5/2011)
That's what Pinal Dave seems to suggest.I've never used it before.
You can enforce the hint using OPTION (ROBUST PLAN) the way you tried.
Will it not compile the SQL...
December 5, 2011 at 8:00 am
dilip.aim11 (12/5/2011)
But in front end i can't rearrange this data....for this i again need recursion..
You can't (some limitations) / you don't know. In second case, I would recommend you to...
December 5, 2011 at 7:55 am
It sounds OK. Just make sure once you enable jobs they restore the backups in proper sequence (without breaking the chain).
December 5, 2011 at 7:43 am
In any case you need to do Date Mathematics to get the local date (or UTC Date).
Scenario 1:
A business house may have Business Hours defined. They need to be calculated...
December 5, 2011 at 7:40 am
If data presentation is your issue, then SQL Server is not the right place to look for the answers. It should be managed at Presentation Layer (application).
December 5, 2011 at 7:17 am
Alternate Solution: FileSystem Object (FSO)
Reading and Writing Files in SQL Server using T-SQL
December 5, 2011 at 7:09 am
You may also use SQL Profiler to generate traces.
December 5, 2011 at 6:48 am
Please check its execution plans (Estimated / Actual).
December 5, 2011 at 6:47 am
dale.schwabjr (12/5/2011)
Also, the only other difference is..I am running SQL 2005 SP4 instead of...
December 5, 2011 at 6:40 am
chetanr.jain (12/5/2011)
@dev ..Why should i manipulate the secen to make my life hell.... 😛
and question has come from the DEV team / support team only......
...
Then this Developer possesses the...
December 5, 2011 at 6:35 am
It's a standard error and SQL Server works that way.
'The minimum row size would be 8214, including 7 bytes of internal overhead. This exceeds the maximum allowable table row size...
December 5, 2011 at 6:31 am
Why does the developer want a % of CPU rather than an actual count of ms of CPU time used
Developer may not ask for it but a Manager (absolutely...
December 5, 2011 at 6:17 am
Viewing 15 posts - 1,096 through 1,110 (of 2,008 total)