Gail Shaw

Forum Replies Created

Viewing 15 posts - 15,541 through 15,555 (of 49,552 total)

RE: Restore with recovery

Welsh Corgi (11/23/2012)
Was your intent to restore additional backups?
He's trying to fail database mirroring over to the mirror after the principal crashed.
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 23, 2012 at 2:18 am

#1561794
RE: Restore with recovery

From Books Online:
FORCE_SERVICE_ALLOW_DATA_LOSS
Forces database service to the mirror database after the principal server fails with the database in an unsynchronized state or in a synchronized state when automatic failover does...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 23, 2012 at 2:11 am

#1561792
RE: Database 'MyDWdb' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

So the DB is online and working?
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 22, 2012 at 11:35 pm

#1561765
RE: SNAPSHOT Isolation with (NOLOCK) being used all over

SQL_ME_RICH (11/22/2012)
Is there any good reason you can think of to always be using the WITH(NOLOCK) hint in all queries?
None whatsoever
Wouldn't the WITH(NOLOCK) defeat the whole purpose of discouraging against...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 22, 2012 at 2:27 pm

#1561714
RE: Are the posted questions getting worse?

D.Post (11/22/2012)
Sorry skipped straight to my 2cents. (Nearly time to go home :-))
Maybe this has already been pointed out and I'm just proving the point of many comments already raised...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 22, 2012 at 11:32 am

#1561693
RE: Does READ_COMMITTED_SNAPSHOT ignore ROWLOCK hints?

Should be OK because ROWLOCK is not an isolation level hint, it's a lock granularity hint. It says 'when you take locks, take at the row level not page or...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 22, 2012 at 11:31 am

#1561692
RE: Failed Simple Maintenance Plan only when Full Backups do not run

See my earlier post. You have an index rebuild job that is rebuilding every single index in your database every time it runs.
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 22, 2012 at 11:25 am

#1561688
RE: Why is my transaction log full?

Has the DB just been switched from full or bulk-logged recovery? If so, run a checkpoint, sys.databases is not updated immediately, hence you can get 'log backup' occurring for a...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 22, 2012 at 11:23 am

#1561687
RE: Business Intelligence on the Developer computer

kenzomus (11/22/2012)
Can we download BIDS for sql server 2008 r2 online ?
No, it's part of the SQL Server installation. Run the SQL Server installation on their machine and just select...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 22, 2012 at 7:49 am

#1561642
RE: Performance issue while fetching 20000000 records

Please post the actual complete procedure, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 22, 2012 at 7:43 am

#1561640
RE: DBCC TABLE CHECK

It's probably the hidden database snapshot that CheckDB uses.
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 22, 2012 at 7:35 am

#1561637
RE: Why does my log show two backup events for the same database?

There is something running a second backup job on that server. The LSNs and times are different, hence it is not the same backup being logged twice. VDI means it'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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 22, 2012 at 7:34 am

#1561636
RE: Failed Simple Maintenance Plan only when Full Backups do not run

josh.hill (11/21/2012)
A successful simple maint plan will consume between 40% and 80% of the trans log. A failure will max out the log. What other pieces of...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 22, 2012 at 4:32 am

#1561589
RE: How to find which are all databases are in use in sql server 2008

nhimabindhu (11/22/2012)
hi,
I am not getting all databases names in the server from sys.dm_db_index_usage_stats because sql server was restarted last week.
The ones you aren't...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 22, 2012 at 4:31 am

#1561586
RE: How to find which are all databases are in use in sql server 2008

No, not conclusively.
You can check the index usage stats for a DB, if there's nothing in there then the DB hasn't been used since the last time the server was...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 22, 2012 at 2:42 am

#1561543

Viewing 15 posts - 15,541 through 15,555 (of 49,552 total)