Viewing 15 posts - 29,851 through 29,865 (of 49,552 total)
Are you doing diff backups? If not, it's not so critical to use the copy_only option
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
October 20, 2010 at 2:15 am
You get a database user that does not have an associated login. Since it has no login, it can only be used for impersonation, you can't connect to SQL using...
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
October 20, 2010 at 2:14 am
On a database created on 2005 or 2008, no difference at all. On databases created on those versions, data purity checks are done by default.
On a database created on 2000...
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
October 20, 2010 at 2:12 am
PaulB-TheOneAndOnly (10/19/2010)
That would be Project Madison - the Data Warehouse appliance.
Madison, renamed as "SQL Server 2008 R2 Parallel datawarehouse edition". Is that still delayed? I thought it was supposed 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
October 19, 2010 at 11:59 pm
You don't ever want to use Profiler gui against a production server. Use a server-side trace and trace to a fast local drive instead.
http://scarydba.wordpress.com/2008/12/18/profiler-research/
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
October 19, 2010 at 11:57 pm
Please post new questions in a new thread.
Thanks
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
October 19, 2010 at 11:45 pm
Inline or multi-statement table valued udfs?
The multi-statement can be nasty with larger row counts.
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
October 19, 2010 at 12:17 pm
SkyBox (10/19/2010)
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
October 19, 2010 at 11:59 am
That looks like the results of running a checkDB with repair allow data loss. Has anything like that been run? Check error logs maybe.
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
October 19, 2010 at 11:52 am
Grant Fritchey (10/19/2010)
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
October 19, 2010 at 11:39 am
Senthil Varadharajan (10/19/2010)
Hi GilaMonster,Can you explain me how to restore from the transaction log.
I explained to you how to restore from backups, including a transaction log backup.
If you mean without...
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
October 19, 2010 at 11:22 am
Restore from backup.
Restore the last full backup as a new DB. Restore transaction log backups up until the time of the update.
Bring the new DB online
Copy the data back...
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
October 19, 2010 at 5:39 am
Help me do the impossible: http://www.sqlservercentral.com/Forums/Topic1006743-357-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
October 19, 2010 at 5:38 am
Gianluca Sartori (10/19/2010)
Oliiii (10/19/2010)
Missing index suggestions don't help much, as I can't build an index with 40 included columns. 🙂
You can. It may not be a good idea, but 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
October 19, 2010 at 5:31 am
subha.mcts2005 (10/19/2010)
we are not maintaining any High availability like replication/Logshipping/mirroing/clustering?
Then there's not a chance in hell of achieving 0 data loss no matter what the disaster situation. What happens if...
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
October 19, 2010 at 5:28 am
Viewing 15 posts - 29,851 through 29,865 (of 49,552 total)