Viewing 15 posts - 34,126 through 34,140 (of 49,552 total)
Possibly because they're doing something that doesn't work in fibre mode. There's a number of things that don't. Difficult to say for sure though.
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
February 9, 2010 at 8:51 am
SQL does not randomly change its configuration settings. Someone went in and enabled that feature.
Check the SQL Error log, there will be an entry in there from when the...
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
February 9, 2010 at 7:08 am
Start by identifying queries that are performing badly.
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
February 9, 2010 at 7:05 am
Gary Varga Old (2/9/2010)
The level of quality appears to vary greatly. Most are very good. Occasionally, I have been given reason to call into question the person's award.
I would...
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
February 9, 2010 at 7:00 am
You can do asynchronous mirroring without a witness, but it doesn't have the same level of data protection as synchronous, manual failover is required and there's a chance of data...
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
February 9, 2010 at 6:55 am
paul.knibbs (2/9/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
February 9, 2010 at 4:41 am
EdVassie (2/9/2010)
Although it is right that people with high-level rights are trusted, it is also important to verify they are not abusing that trust.
Absolutely.
Any unexpected restart of the SQL...
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
February 9, 2010 at 4:33 am
Considering it requires local administrator permissions, I wouldn't really call it a back door. Someone with local admin could just as easily stop SQL and copy off the data and...
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
February 9, 2010 at 2:59 am
Please read through this - Managing Transaction Logs[/url]
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
February 9, 2010 at 2:58 am
Please post table definitions, index definitions and actual execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
The exec plan that you posted earlier is the estimated plan and is missing certain key information.
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
February 9, 2010 at 2:52 am
Henrico Bekker (2/8/2010)
Microsoft E-Learning
There is no Microsoft E-Learning training currently available.
Microsoft Press Books
There are no Microsoft Press books...
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
February 9, 2010 at 12:27 am
Maybe, but you should test. The time for restoring the full won't change. Whether the restoring of all the tran logs is faster or slower than a single diff, that...
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
February 9, 2010 at 12:24 am
Roust_m (2/8/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
February 9, 2010 at 12:15 am
Have a look at this thread where the complexities of 'unrecoverable deletes' was discussed.
http://www.sqlservercentral.com/Forums/Topic857162-391-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
February 8, 2010 at 10:09 pm
Well, all the study books are copyrighted, and I'm sure you're not asking for illegal material. Most of the free stuff is questionable and often braindumps (questions taken straight from...
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
February 8, 2010 at 10:01 pm
Viewing 15 posts - 34,126 through 34,140 (of 49,552 total)