Viewing 15 posts - 32,656 through 32,670 (of 49,552 total)
Query sys.databases. What's the value for log_reuse_wait_desc for that 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
June 1, 2010 at 8:31 am
You restored the diff WITH RECOVERY, indicating that was the last backup that you wanted to restore and that the DB must come online. If you want to restore log...
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
May 31, 2010 at 12:48 pm
Very good book.
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
May 31, 2010 at 12:21 pm
Tom.Thomson (5/31/2010)
GilaMonster (5/30/2010)
This one's not much better...http://www.sqlservercentral.com/Forums/Topic929458-357-1.aspx
If you have a 2 TB database and don't know how to plan backup and restore strategies, there's a bigger problem there.
Actually from one...
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
May 31, 2010 at 12:20 pm
hxkresl (5/31/2010)
The database is gone. ie. There is no expandable "+" next to the database in Object Explorer, I can't open it. It is also...
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
May 31, 2010 at 12:12 pm
Hmm...
Try the latter 3 books in the Inside SQL Server 2005 series - T-SQL Querying, T-SQL Programming and Query Tuning and Optimisation. Also Grant's e-book (available here) http://www.sqlservercentral.com/articles/books/65831
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
May 31, 2010 at 7:56 am
Sorry, still not completely clear what you're looking for? Background on the query operators? On how the queries are processed? Something else?
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
May 31, 2010 at 7:39 am
dronov (5/31/2010)
Does it mean i have no hope ?
Correct.
You may be able to extract data/objects from the database as it is now, that's the best you're going to be able...
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
May 31, 2010 at 7:25 am
dr_csharp (5/31/2010)
do u know any references to understand these differences scientifically ?
My explanations weren't scientific enough? Did you read through the posts referenced in the first of those links?
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
May 31, 2010 at 7:23 am
Gopi Muluka (5/31/2010)
change second query to below to match the resultsets
Select Distinct orderId,orderDateFrom orders
Inner join orderDetails
On orders.orderId=orderDetails.orderId
Where orderDetails.unitePrice>3
In this case both will have same kind of performance;-)
'
Hell 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
May 31, 2010 at 7:20 am
If you test them out, which is faster? Do note that they are not necessarily equivalent queries
These may be of interest -
http://sqlinthewild.co.za/index.php/2010/04/27/in-exists-and-join-a-roundup/
http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/
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
May 31, 2010 at 6:57 am
When you need to filter on columns other than the clustered index.
This may help. http://www.sqlservercentral.com/articles/Indexing/68439/ (3-part series)
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
May 31, 2010 at 6:55 am
Those errors don't look promising.
Log's rebuilt, but it looks like there's data file corruption too. Whatever the IO subsystem did here to cause the corruption, it did a thorough job.
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
May 31, 2010 at 6:48 am
Please post table definitions, sample data and expected results as per 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
May 31, 2010 at 6:15 am
Odd, emergency should imply single user. Did you do anything at all to the DB since setting it to emergency?
Try and set it single user.
Alter Database InProSys SET Single_user
If there...
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
May 31, 2010 at 6:06 am
Viewing 15 posts - 32,656 through 32,670 (of 49,552 total)