Viewing 15 posts - 751 through 765 (of 928 total)
Someone has landed a job as a DBA and hasn't heard about recovery models.
http://www.sqlservercentral.com/Forums/Topic966360-1292-1.aspx#bm966429
Could someone take over please, I was trying to be helpful until the last reply and I've...
August 10, 2010 at 2:25 am
A thought just occurred to to me - do you have a DBA there, or someone with responsibility for monitoring and maintaining the databases? If so, they should have some...
August 10, 2010 at 2:16 am
webmaster 27466 (8/10/2010)
Basically what I want to do is
a)Create a full backup
This way every day at 8:00PM there will be an identical copy of...
August 10, 2010 at 2:11 am
webmaster 27466 (8/10/2010)
Backing up ALL changes is relevant as the data is important and all relevant to other data elsewhere in the database.
I have scheduled a daily backup but I...
August 10, 2010 at 1:50 am
webmaster 27466 (8/9/2010)
How do I use SQL Trace to record ALL actions preformed on the database to a file?
Have a look at what is available when you choose 'Show All...
August 10, 2010 at 1:33 am
atikdesai (8/2/2010)
Hello,I have parameters in store procedure called @date_from and @date_to. Both have data type varchar.
TransactionDate has data type of varchar(50).
You have three fields that are used as date...
August 3, 2010 at 1:29 am
ian.procter (7/27/2010)
July 27, 2010 at 4:10 am
Yeah, I'm hoping the multiple-choice questions have 'it depends' as an option - I'll sail through it!
BrainDonor.
June 18, 2010 at 2:18 am
Dave Ballantyne (6/18/2010)
Derived tables are not temp table (either # or @)
I realise that, but it was bit in italics that I found confusing. It implies that temporary tables always...
June 18, 2010 at 2:06 am
GilaMonster (6/16/2010)
sachnam (6/16/2010)
Temp table or Hash(#) tables are kept in the data file of a Tempdb database till the session...
June 18, 2010 at 1:46 am
You are now officially 'my kind of person'! :w00t:
And that's a good thing.....?:hehe:
June 1, 2010 at 9:49 am
I think you're right, but I'm not sure the exam delves this far down.
I suspect that is true, but personally I hate to just 'skip over' something that is...
June 1, 2010 at 9:43 am
Thank you very much for that link - I don't think there'll be any questions for a day or two!
BrainDonor.
June 1, 2010 at 7:21 am
Can I pass this one around for assistance?
http://www.sqlservercentral.com/Forums/Topic927236-357-1.aspx#bm927248
New visitor, looks like they want to transfer 2008 db objects to 2000, backup (in 2000), zip it, ftp it and controll all...
May 25, 2010 at 3:37 am
If I understand you correctly, what you want to do is backup a database that is being used on a SQL Server 2008 system and restore it on a SQL...
May 25, 2010 at 1:34 am
Viewing 15 posts - 751 through 765 (of 928 total)