Viewing 15 posts - 38,611 through 38,625 (of 49,552 total)
b.ozga (6/8/2009)
Do you know a way to attach\create database on a disk which is not SQL Server dependency but it is in a cluster group? Any help appreciated.
Can't be done....
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 8, 2009 at 3:03 am
You'll have to restore the backup. There's no tool I know of that reads inside a SQL backup.
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 8, 2009 at 3:01 am
vivek (6/1/2009)
then did we saw any difference? Can you share it with us?
** I capture the execution plan...
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 8, 2009 at 2:59 am
They are. I'm just wondering if there's something missing around the provisioning tool with SP3. It's not something I've ever tested, so can't be sure either way.
Install SP2, make sure...
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 8, 2009 at 2:50 am
It is not.
Shrinking causes massive fragmentation and will just result in the data file growing again next time data gets added. When that happens, the entire system will slow down...
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 7, 2009 at 4:16 pm
Try installing SP2 before SP3. The prov tool launches automatically at the end of SP2
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 7, 2009 at 4:04 pm
RBarryYoung (6/7/2009)
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 7, 2009 at 2:59 pm
On Vista the administrator user no longer has automatic rights to SQL. The provisioning tool should have come up at the end of the service pack installation to allow 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
June 7, 2009 at 1:05 pm
Is this an agreement party? 😉
One other book I'd recommend, more for development than admin. T-SQL Fundamentals by Itzik Ben-Gan. It's written for SQL 2008, not 2005, but they are...
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 7, 2009 at 5:22 am
Paul White (6/7/2009)
I mentioned it because I based my first post on the content of pages 199-200.
Yeah, I noticed the similarity between your post and the book when I checked...
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 7, 2009 at 5:17 am
Paul White (6/7/2009)
Inside Microsoft Sql Server 2005: Query Tuning and Optimization - K Delaney et al.ISBN-13: 978-0-7356-2196-1
ISBN-10: 0-7356-2196-9
(I just happened to have a copy to hand ;-))
Nope. Algebriser doesn't even...
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 7, 2009 at 4:49 am
Paul White (6/7/2009)
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 7, 2009 at 1:42 am
Does the SQL Server service account have full rights to the database files? The error implies that it doesn'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
June 7, 2009 at 12:54 am
SQL goes through three stages before executing the query. Parse, algebratise and compile. All three operate on the entire batch, regardless of whether the statements will actually run or not....
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 7, 2009 at 12:51 am
RBarryYoung (6/6/2009)
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 7, 2009 at 12:47 am
Viewing 15 posts - 38,611 through 38,625 (of 49,552 total)