Viewing 15 posts - 44,326 through 44,340 (of 49,552 total)
From the looks of the diagram, that database has very few primary keys and no foreign keys. How are you planning on enforcing data integrity?
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
September 22, 2008 at 6:29 am
In simple recovery the log shouldn't grow large as old log records are automatically discarded when they are no longer necessary. If the log is growing in simple recovery, then...
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
September 22, 2008 at 6:23 am
Restore the full backup somewhere, apply the log backups until just before the table was dropped, then copy the table from there into the real database.
If you had a database...
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
September 22, 2008 at 6:21 am
It might (if you ran it) be in the plan cache. If not, and there wasn't a trace running, then no.
select * from syscacheobjects
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
September 22, 2008 at 6:10 am
Well if you know the databases, you could hardcode the names in the insert statements. If you don't want to do that, then this should work, providing the login that'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
September 22, 2008 at 5:49 am
Robert (9/22/2008)
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
September 22, 2008 at 2:23 am
Still possible. Do you know which DBs have that table (is it fixed), or does that change over time?
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
September 22, 2008 at 2:18 am
Sure, providing your login has rights to the other databases. You just need to use the 3 part naming - database.schema.object, so
insert into database1.dbo.user_table ...
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
September 22, 2008 at 1:42 am
SQLBOT (9/21/2008)
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
September 22, 2008 at 1:34 am
Sure. It's just a text file. You won't be able to save it, but then you shouldn't make changes to it.
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
September 22, 2008 at 1:30 am
Typically deadlocks are the result of poorly written code or poor indexing, but then so is bad performance in general.
Are the deadlocks recurring? If so, turn traceflag 1222 on (DBCC...
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
September 22, 2008 at 1:29 am
samsql (9/21/2008)
Also try this.....DBCC CHECKTABLE('audit_record',REPAIR_FAST) can not fix this problem.
DBCC CHECKTABLE('audit_record',REPAIR_ALLOW_DATA_LOSS)
Do not, do not, do not run repair as the first thing tried when dealing with corruption. It should be...
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
September 22, 2008 at 1:23 am
sp_readerrorlog will show you the current error log for the server as a resultset.
The error log's not stored in a table so there's no direct query. It's a file (called...
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
September 22, 2008 at 1:20 am
What's the recovery requirements for that database? If the DB crashes at 1pm, is it acceptable to restore to the last full backup?
If not, then you need to run transaction...
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
September 22, 2008 at 1:17 am
Pleasure.
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
September 21, 2008 at 2:14 pm
Viewing 15 posts - 44,326 through 44,340 (of 49,552 total)