Viewing 15 posts - 27,226 through 27,240 (of 49,552 total)
Second request, seeing as I seem to have scared people away
I'm looking for a couple (and I do mean 2) editors for a non-SSC piece on page restores. Please do...
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
March 21, 2011 at 1:47 pm
SQLkiwi (3/21/2011)
Roy Ernest (3/21/2011)
You are flying all the way to Boston from NZ? Thats a pretty long flight you will be in.. 🙂
About 40 minutes short of 24 hours travelling...
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
March 21, 2011 at 1:41 pm
Patricia Johnson (3/21/2011)
Gail, isn't there a % that you can use that is "sort of" a best for almost all?
No. You can pick some value as the standard and use...
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
March 21, 2011 at 1:39 pm
Vertigo44 (3/21/2011)
Does SQL server delete them from the file system knowing the database was recovered without them therefore it thinks they aren't needed?
Absolutely not. Database restored in no way means...
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
March 21, 2011 at 1:34 pm
The 'strong password' requirements are based off the domain's password policy. Check what that is.
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
March 21, 2011 at 1:08 pm
Patricia Johnson (3/21/2011)
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
March 21, 2011 at 1:06 pm
Jeff Moden (3/21/2011)
Rao.V (3/21/2011)
you also can use option called "SEQUENCE" for that column so that it generates number automatically when u insert a new rowRao.V (3/21/2011)
yes i mean identity???:blink: 😛
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
March 21, 2011 at 11:53 am
Please note: 3 year old thread
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
March 21, 2011 at 11:37 am
WayneS (3/21/2011)
2. Does anyone want to be a quality check on this question before I submit it?
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
March 21, 2011 at 10:04 am
Minimally logged operations
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
March 21, 2011 at 8:58 am
Please note: 8 year old thread.
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
March 21, 2011 at 8:00 am
Send the query (and just the query that's showing this behaviour, not the entire stored proc) to the DBA and ask him to run it with the actual plan on.
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
March 21, 2011 at 7:40 am
That is an estimated plan. It's missing a whole lot of useful information.
Please run the query (and just the query that's of interest, not the entire procedure) with the 'Include...
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
March 21, 2011 at 7:21 am
sqlchanakya (3/21/2011)
It my bad....11%
What's 11%?
Ninja was talking about the sp_config setting Cost Threshold for Parallelism, which is a number, default 5.
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
March 21, 2011 at 7:13 am
I'm looking for a couple (and I do mean 2) editors for a non-SSC piece on page restores. Please do not volunteer if you are not willing and able to...
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
March 21, 2011 at 7:09 am
Viewing 15 posts - 27,226 through 27,240 (of 49,552 total)