Viewing 15 posts - 47,626 through 47,640 (of 49,571 total)
David Lester (1/23/2008)
So anyone have any thoughts on this? Any suggestions on how to explain why a DBA would be important to have?
Thanks!
Ask management what their disaster recovery plans are....
January 24, 2008 at 12:46 am
Mike Landa (1/23/2008)
Gail,do i need to run SQLDiag to post Error log here ?
No. It's written into the normal sql server error log. You can view the error log through...
January 24, 2008 at 12:44 am
Jeff Moden (1/23/2008)
don't really see the point of an unique index with ignore duplicates on. Am I missing something?
It's a cheater method for removing dupes during a Bulk Insert...
January 24, 2008 at 12:34 am
If you create a temp table in a procedure, then any procedures you call from that one will be able to see the temp table. If you create a...
January 23, 2008 at 11:59 am
My ASP is rusty but ....
Ray M (1/23/2008)
'str = "if not exists (SELECT * FROM Checklist_Justify WHERE iAsmtID="&iAsmtID&")"'str = "INSERT INTO Checklist_Justify (iAsmtID, sQuest, sJustify) VALUES ("&iAsmtID&","&sQuest&",'Testing')"
Unless I'm very mistaken,...
January 23, 2008 at 11:53 am
Switch trace flag 1204 on. That makes SQL write the deadlock graph into the error log. It's not as pretty as the profiler version, but it will work.
If you're unsure...
January 23, 2008 at 11:44 am
Jeff Moden (1/19/2008)
January 23, 2008 at 11:34 am
Shouldn't make a difference. Certainly won't cause a hash-operation. Probably they're queries someone 'wrote' using enterprise manager, which puts that in by default.
In the exec plan, you should see the...
January 23, 2008 at 8:09 am
dsc (1/23/2008)
There is a high degree of fragmentation on the indexes.
Rebuilding your indexes is an obvious suggestion.
Can you post the table structure, indexes and the code that's causing the table...
January 23, 2008 at 8:04 am
One of the things to watch for with table-valued functions (especially the multi-statement table valued functions) is that the resultant table, just like a table variable) has no column statistics...
January 23, 2008 at 8:02 am
I haven't tried it, but it should be possible to recover all the way.
Full backups don't truncate the transaction log (only tran log backups do that) so you should...
January 23, 2008 at 2:01 am
And the code you're using to check existence and insert also, please.
January 23, 2008 at 1:48 am
You're looking for a left outer join (to get all rows from tab1 even where there aren't matches) and a case statement to construct the WorkFlag depending on the existence...
January 19, 2008 at 10:04 am
Count (*) will give you the total number of rows in the result set. Count(column name) give you the number of non-null values in the column.
If there are nulls in...
January 19, 2008 at 10:00 am
If you have an explicit transaction and within that transaction you reference a remote server, the transaction will be promoted to a distributed transaction.
From the error, it looks like the...
January 19, 2008 at 9:56 am
Viewing 15 posts - 47,626 through 47,640 (of 49,571 total)