Viewing 15 posts - 1,036 through 1,050 (of 1,999 total)
Krasavita (6/8/2012)
Hello, it is probably impossible,but maybe a chanceI deleted a database and my backup was deleted where I made a copy,is there way to restore some how?
Thank you
do you...
June 8, 2012 at 8:57 am
yes
select count(distinct orglevel)
,x
,y
,z
from ...
where x=a
group by
x
,y
,z
June 8, 2012 at 8:54 am
try the following
declare @mydate datetime
set @mydate=GETDATE()
SELECT dateadd(dd,4,CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,@mydate))-1),DATEADD(mm,1,@mydate)),101) )
see Pinal Dave's blog post on these
edit: the other suggestions are better than mine - i did a cut an poste from...
June 8, 2012 at 8:50 am
dwilliscp (6/8/2012)
June 8, 2012 at 8:37 am
Mathew M.Varghese (6/8/2012)
Why is the execute count (which is just a measure of how many times an operator in the query runs) a problem? Is this query slow?
Yes the query...
June 8, 2012 at 8:34 am
anthony.green (6/8/2012)
BaldingLoopMan (6/8/2012)
is there a way to temporarily turn off the writting to trans log for this process?
everything is written to the transaction log you cannot stop that, it all...
June 8, 2012 at 8:27 am
rwiethorn (6/8/2012)
Regarding your LogParser Jobs,
Are You running and importing on the same server?
I'm trying to run on Server1, and read on Server2.
I get denied access when the LogParser,...
June 8, 2012 at 8:25 am
A.NIF+ISNULL(A.FILIAL_NUMBER,'') = B.NIF+ISNULL(B.FILIAL_NUMBER,'')
A.NIF+ISNULL(A.FILIAL_NUMBER,'''') = B.NIF+ISNULL(B.FILIAL_NUMBER,'''')
you didn't account for using quotes inside your dynamic sql
June 8, 2012 at 8:14 am
BaldingLoopMan (6/8/2012)
is there a way to temporarily turn off the writting to trans log for this process?
yes, but it's not without pre-requisite actions - you must follow these in the...
June 8, 2012 at 8:11 am
+1 sturner
however i did find on most of my configurations that 1000 is too small (as a rule of thumb) and that between 10k and 100k rows gave the best...
June 8, 2012 at 7:55 am
and before anyone follows that up with "it's not disk fragmentation" - what i mean is , it's the fragmentation of the index within the data file (not the fragmentation...
June 8, 2012 at 7:48 am
jitendra.padhiyar (6/8/2012)
GilaMonster (6/8/2012)
Internal fragmentation being?
External Fragmentation: External Fragmentation happens when a dynamic memory allocation algorithm allocates some memory and a small piece is left over that cannot be effectively used....
June 8, 2012 at 7:43 am
wertyui (6/8/2012)
michael vessey (6/8/2012)
IF @NextOrderNo is null
begin
SET @OrderNo = (SELECT NextNo FROM NxNo (Nolock))
update NxNo set NextNo = NextNo @increasevalue
end
1) remember to use the WITH...
June 8, 2012 at 5:05 am
or make your column NOT NULL - and set a default value that means "unassigned"
e.g (using a mocked up status table)
status value
1 ...
June 8, 2012 at 5:03 am
I Thought there might be a way to do this with DENSE_RANK(), but i'm struggling
June 8, 2012 at 5:00 am
Viewing 15 posts - 1,036 through 1,050 (of 1,999 total)