Viewing 15 posts - 5,551 through 5,565 (of 49,552 total)
Brandie Tarvin (6/19/2015)
I'm looking at new laptops (Lenovo was recommended to me) and would like to set up some VMs for testing SQL Server stuff.
As an alternative, Microsoft's Azure...
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 19, 2015 at 8:07 am
dhanekulakalyan (6/19/2015)
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 19, 2015 at 7:46 am
Jeffery Williams (6/19/2015)
Time for more coffee!
Always!
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 19, 2015 at 7:11 am
Jeffery Williams (6/19/2015)
I just read it. And basically my question is already in this format.
Err... The link in his post, not the one in his signature
Phil Parkin (6/19/2015)
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 19, 2015 at 7:04 am
Jeffery Williams (6/19/2015)
I explained the issue, supplied my code and the output.
Did you read the link he provided? The one in his post, not the ones that are part of...
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 19, 2015 at 6:53 am
VMware Workstation. Doesn't need a server OS.
Camtasia for video recording.
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 19, 2015 at 6:12 am
Really, really bad idea.
Unless he makes sure that the drive is only removed after the first machine is shut down and plugged in before the second machine is started up,...
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 19, 2015 at 5:29 am
Last I heard, no less than 1-2 million dollars, and that doesn't include the code changes you'll need for the PDW, the training, the re-design of the DB to handle...
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 19, 2015 at 2:43 am
The MCSE-level exams got updated to include 2014 material, the MCSA-level ones didn'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 19, 2015 at 2:32 am
Both. Which it will pick depends on data, query, table and a pile more things.
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 19, 2015 at 2:31 am
Waits has little to do with physical time, and nothing to do with cores either. It's the collective time that processes have spent waiting.
Imagine a queue in a bank. If...
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 19, 2015 at 2:28 am
Maybe. Test, and see if there's any impact.
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 18, 2015 at 11:02 am
Passwords shouldn't be encrypted. Encryption assumes that you need to retrieve the original value, which for a password you don't. Passwords should be stored as a salted hash, preferably hashed...
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 18, 2015 at 9:39 am
A backup contains only the allocated extents.
When restored, a database is recreated exactly as it was at the time of 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 18, 2015 at 9:25 am
First thing you can do is remove the index hint. Then test the performance again. If it's still unacceptable, post the table definitions, index definitions and 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 18, 2015 at 7:04 am
Viewing 15 posts - 5,551 through 5,565 (of 49,552 total)