Viewing 15 posts - 38,116 through 38,130 (of 49,552 total)
Looks good.
I know there are scripts around (google should find) that can build a full restore script from the backup records in msdb when all the backups are to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2009 at 2:31 pm
Lynn Pettis (6/27/2009)
GilaMonster (6/27/2009)
Could well be. Should I reply with some relational theory?
Sounds like a plan to me. I couldn't, it's been so long I just barely remember anything...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2009 at 2:30 pm
Eros (6/27/2009)
Surely, "TRUNCATE TABLE" gave me a very impressive quick response "Command(s)...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2009 at 1:02 pm
rambilla4 (6/27/2009)
1.Backing up the Full, Diff and Log backups to the same backup device(PROD_06-25-2009.bak) is Preffered? or
2.Backing up the Full to Z:\Backups\Full\prod.bak
Backing up the Diff...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2009 at 12:49 pm
It should be
RESTORE HEADERONLY FROM FILE = < Backup file location >
You're not restoring from a database, you're restoring from a file.
p.s. Backing up multiple different backup types to the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2009 at 11:22 am
Threads once posted can't be deleted. If you post in the wrong forum, either note it in the post and request the mod to move it (via Report), or post...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2009 at 11:20 am
Could well be. Should I reply with some relational theory?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2009 at 10:14 am
An interesting response here. Anyone understand what he's asking?
http://www.sqlservercentral.com/Forums/Topic743113-391-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2009 at 9:52 am
Could you perhaps clarify and expand on your question so that someone can help you?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2009 at 9:47 am
John (6/27/2009)
If you have a STATS_DATE of NULL, does that always mean you should skip running update stats on an object?
As far as I'm aware, Stats_date of NULL means that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2009 at 9:46 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic743117-5-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2009 at 9:42 am
John (6/27/2009)
- Make sure the table has data (actually, I've read that it should really have more than 8 pages to be effective)
As I mentioned earlier in this thread, the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2009 at 9:16 am
Please read the article.
I'll put what you gave into the suggest format, but there's a lot of info that I don't have. Also please post your expected results based off...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2009 at 9:14 am
Sorry, but I'm not sure I understand what your question is
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2009 at 8:13 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2009 at 7:24 am
Viewing 15 posts - 38,116 through 38,130 (of 49,552 total)