Viewing 15 posts - 1,036 through 1,050 (of 1,995 total)
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
S_Kumar_S (6/8/2012)
But my where clause is not doing comparision with NULL. it is doing comparision with 0.And since NULL is not a zero, those records should come logically.
no - not...
June 8, 2012 at 4:51 am
anthony.green (6/8/2012)
the N specifies that the following string is a NVARCHAR stringN'\\XXXXXXXX\W$\LOG_BACKUP\XXXXXXXX_tlog_201206072000.TRN'
Your actually backing up to \\XXXXXXXX\W$\LOG_BACKUP\, not the N drive
Edit
Mike beat me to it again
lol - my kung fu...
June 8, 2012 at 4:48 am
jblovesthegym (6/8/2012)
BACKUP failed to complete the command BACKUP LOG [XXXXXXXX] TO DISK = N'\\XXXXXXXX\W$\LOG_BACKUP\XXXXXXXX_tlog_201206072000.TRN' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
This is odd as...
June 8, 2012 at 4:46 am
have a look through books online - or google "NULL EVALUATION SQL SERVER"
http://stackoverflow.com/questions/1843451/why-does-null-null-evaluate-to-false-in-sql-server
http://msdn.microsoft.com/en-us/library/ms172138(v=vs.80).aspx
basically (in simplest terms) NULL does not evaluate: you cannot say =NULL or <> NULL
you can use the...
June 8, 2012 at 4:42 am
Viewing 15 posts - 1,036 through 1,050 (of 1,995 total)