Viewing 15 posts - 18,121 through 18,135 (of 49,552 total)
jeff.mason (6/12/2012)
Interesting that Prometric is updated but that the MCP website is not.
On the MCP site it states that it can take up to 7 days for the latest exams/certs...
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 12, 2012 at 7:39 am
As Ole said, that's dependent on the data, the queries, the execution plans chosen, etc. It's not hard and fast good or bad.
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 12, 2012 at 4:31 am
Because you have two logically different queries there.
That's why there are different performance characteristics and why you still have to filter in the where even with the 'filter' in 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
June 12, 2012 at 4:28 am
sqlactions (6/12/2012)
Any user who can create a database can create a database snapshot; however, to create a snapshot of a mirror database, you must be a member of 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
June 12, 2012 at 4:13 am
No, neither definition is correct.
Typically:
Internal fragmentation: space free on pages within the index. Shown by avg_page_space_used_in_percent in sys.dm_db_index_physical_stats.
External fragmentation: pages out of order within the index (logical order doesn't match...
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 12, 2012 at 4:11 am
You could start by what Jonathan says in his blog post, the paragraph right below where he lists the counters.
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 12, 2012 at 4:08 am
http://support.microsoft.com/?id=956893
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 11, 2012 at 2:41 pm
krypto69 (6/11/2012)
Okay. My understanding is that they are only using NetApp to backup/snapshot those instances. Not the entire VM.
It needs to be a backup synced with SQL Server (hence appearing...
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 11, 2012 at 2:27 pm
Koen Verbeeck (6/11/2012)
GilaMonster (6/11/2012)
The way I search for plagiarism/copyright violation is to take a random sentence out of a paragraph and google for that sentence (in quotes)
That wouldn't really have...
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 11, 2012 at 2:06 pm
That's not what I said. Taking snapshot backups of the VM and expecting to be able to restore SQL with them at is not supported. Doesn't matter who or 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
June 11, 2012 at 2:04 pm
Just to reiterate and emphasise....
You are hashing those passwords according to all recommended practices? Strong hash with salt? If not, see what happened to LinkedIn and imagine it happening 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
June 11, 2012 at 1:59 pm
krypto69 (6/11/2012)
Thanks Lynn.
Err...???
That is exactly what they are doing.
Anything I can do to help them?... Other than "not supported too bad".
Yes, set up proper backups according to the business's RTO...
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 11, 2012 at 1:58 pm
I do hope they're not taking snapshot backups of the VM and expecting those to work as SQL backups. That backup 'strategy' is not supported.
Please read through this - Managing...
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 11, 2012 at 1:32 pm
Just one nitpick... Lose the ;. CTEs don't start with statement terminators.
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 11, 2012 at 1:30 pm
1) Turn the caps lock off.I don't appreciate being shouted at.
Yes, that will work once you fix the duplicate brackets. There's a line where you have (( and )) instead...
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 11, 2012 at 1:29 pm
Viewing 15 posts - 18,121 through 18,135 (of 49,552 total)