Viewing 15 posts - 24,856 through 24,870 (of 49,552 total)
Peawet (7/18/2011)
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
July 18, 2011 at 3:23 am
The model database is copied to form the new DB and the system objects that are the base for sys.databases, sys.master_files and related ones are updated with the new DB...
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
July 18, 2011 at 3:19 am
If you have log shipping then the log backups taken for the log shipping must be the only ones taken.
You can set log shipping up for read-only. Restore WITH STANDBY...
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
July 18, 2011 at 3:18 am
Jeff Moden (7/17/2011)
most accidental DBA's can't get a company to give them 2 weeks paid training leave.
Most companies won't give a 2 day's paid training leave if it's not an...
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
July 18, 2011 at 3:15 am
Subrata Bauri (7/17/2011)
Sean Lange (7/15/2011)
This really won't let you get an accurate count. It will work until you delete a record. If you want an arbitrary number as your primary...
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
July 18, 2011 at 3:12 am
Jeff Moden (7/17/2011)
Ummm... isn't MCM only two weeks long?
The MCM is 2 exams, no training component. The chance of passing without finding some suitable training however....
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
July 18, 2011 at 3:11 am
You mean SQL 2005? (no such version as SQL 2003)
Where did you buy it through? Sometimes you can call and ask for replacement disks.
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
July 16, 2011 at 3:49 am
whattheETL (7/15/2011)
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
July 16, 2011 at 3:47 am
LAW1143 (7/15/2011)
Rebuilding the clustered index will hit all non clustered indices
No it won't. Rebuilding the cluster only rebuilds the cluster. Doesn't touch the non-clustered indexes.
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
July 16, 2011 at 3:47 am
That's just a GUI thing, it gets the backup history from MSDB if it's there. Instead of selecting databases select device and navigate to the backup. Or write and save...
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
July 15, 2011 at 3:53 pm
Depends. If they use the leading column, yes. If they use the second column in the key (primary or unique, makes no difference here) then no.
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
July 15, 2011 at 3:38 pm
Depends. Which are you going to rebuild.
If you plan on rebuilding all of your indexes between two log backups, then budget for at least 120% the total size for all...
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
July 15, 2011 at 3:38 pm
Depends. If you need to restore testing back to how it was at the time, you can just use the backup from production. If you change things before testing and...
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
July 15, 2011 at 3:33 pm
Doesn't matter. At a school or university if you study from the exam paper that you'll be given it's called cheating. That's what a braindump is, a list of questions...
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
July 15, 2011 at 3:31 pm
sqlfriends (7/15/2011)
So for example I restore my testing database from a version from Production server.Then I don't need to do a full backup after the restore.
A full backup of what?...
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
July 15, 2011 at 3:24 pm
Viewing 15 posts - 24,856 through 24,870 (of 49,552 total)