Viewing 15 posts - 556 through 570 (of 1,065 total)
Is this happening because of OR condition in where clause.
Yes
Try
Select columns_list from REQUEST where BeneficiaryId = 'somedata'
UNION
Select columns_list from REQUEST where InstructorId= 'somedata'
August 3, 2009 at 7:31 am
Have a look at this link http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/
Particularly "The blackbox XML methods"
August 3, 2009 at 5:50 am
appending HAVING will not work with strings..correct?
Not correct... you can use HAVING with strings, but not with BLOB columns e.g. TEXT.
The HAVING clause is effectively a WHERE clause, but acting...
August 3, 2009 at 2:22 am
Going off on another direction entirely. What is happening to IT these days... technical support is c**p.
I have an on-going problem with a printer crashing. Call logged with ** technical...
July 31, 2009 at 2:58 am
Jeff Moden (7/30/2009)
It probably won't do the world any good at all, but I feel MUCH better now...http://www.sqlservercentral.com/Forums/Topic762623-146-1.aspx
Nice one Jeff. I feel better too (even though I had nothing to...
July 31, 2009 at 2:26 am
Does anything else run at 6:00pm that may chew up a bit of space and then release it?
July 30, 2009 at 1:33 pm
The maintenance plan only does the delete phase on successful completion of the backup phase. That way you don't end up without any backups.
For the duration of the backup,...
July 29, 2009 at 8:25 am
What error are you getting?
Why do you need to delay execution of the trigger?
Don't forget, if you put a delay in the trigger, whatever fired the trigger is also going...
July 29, 2009 at 8:17 am
Although the transaction log is included in the full backup, the log is NOT truncated.
If it was, the chain of log backups would be broken by the full backup, and...
July 29, 2009 at 4:37 am
The chances are it's not branching to the GOTO, but dropping into it. You need to put a RETURN immediately after the COMMIT.
July 16, 2009 at 6:08 am
Steve Jones - Editor (7/15/2009)
It might be trying to read the tape headers as well.
It doesn't... it's just agonisingly slow.
I looked into this some years ago on a system where...
July 15, 2009 at 11:35 am
Do you really need 3 months of data?
Take a "common" backup strategy...
Full backups once a week, Differentials daily, Transaction log backups throughout the day... all kept for 2 weeks...
July 15, 2009 at 9:56 am
Zac Mace (7/15/2009)
I think some of you are missing the point - or perhaps I am 🙂
Steve's article is obviously open to interpretation, but
ship something that's 80% right and...
July 15, 2009 at 5:02 am
Just change the date on the server that is hosting your SQL Server instance (which will obviously affect every other system running on the server).
I don't know of a way...
July 15, 2009 at 4:57 am
It could also be due to the amount of backup history being stored
You can use the stored procedure sp_delete_backuphistory in the MSDB database to trim it down.
July 15, 2009 at 3:53 am
Viewing 15 posts - 556 through 570 (of 1,065 total)