Viewing 15 posts - 1,036 through 1,050 (of 1,993 total)
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,...
MVDBA
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
MVDBA
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...
MVDBA
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...
MVDBA
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...
MVDBA
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....
MVDBA
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...
MVDBA
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 ...
MVDBA
June 8, 2012 at 5:03 am
I Thought there might be a way to do this with DENSE_RANK(), but i'm struggling
MVDBA
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...
MVDBA
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...
MVDBA
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...
MVDBA
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...
MVDBA
June 8, 2012 at 4:42 am
If this was a geography forum, you would be the flat earth kid:w00t:
Since you don't know anything about RDBMS, then get a copy of the simplest intro book...
MVDBA
June 8, 2012 at 4:38 am
+1 phil - you beat me to it by 1 minute
also possibly a synonym???
MVDBA
June 8, 2012 at 4:29 am
Viewing 15 posts - 1,036 through 1,050 (of 1,993 total)