Viewing 15 posts - 4,861 through 4,875 (of 49,552 total)
Ed Wagner (9/1/2015)
ZZartin (9/1/2015)
Steve Jones - SSC Editor (9/1/2015)
Passwords: http://www.pcworld.com/article/2978316/security/tired-of-memorizing-passwords-a-turing-award-winner-came-up-with-this-algorithmic-trick.htmlNow if only all websites used the same algorithm to determine whether a password is strong enough.....
That's a neat approach 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
September 1, 2015 at 12:49 pm
Maybe
Depends if the index is useful to the query and the query capable of using the index.
Not knowing how you're replicating the data, it's a little hard to suggest alternatives...
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
September 1, 2015 at 11:51 am
The problem is likely to be the Group By that you have there. I don't know why it's there, because there's no aggregations.
If the group by is removed, and someone...
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
September 1, 2015 at 11:43 am
There's probably either no suitable index, or the update is written in such a way that SQL can't use the index and has to scan the table, hence the table...
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
September 1, 2015 at 8:23 am
Please start a new thread and give us as much information as possible.
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
September 1, 2015 at 5:45 am
It's normal for sessions in parallel to 'block' each other. Your wait times are all around 15-30 ms. Why is this a problem?
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
September 1, 2015 at 5:12 am
Before you implement that, please read this: http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/
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
September 1, 2015 at 2:59 am
For what?
And do you need symmetric encryption or asymmetric?
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
September 1, 2015 at 2:58 am
How many physical cores per processor? Don't look at SQL, check the specs of the processor you 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
September 1, 2015 at 2:57 am
Thanks everyone
I'm leaning towards getting a 256 GB SSD for the OS and then 2 (or 3) 1TB drives for all the large stuff (databases, graphics resources for my 3D...
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
September 1, 2015 at 2:54 am
What exactly do you mean by 'configuring virtual memory'?
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
September 1, 2015 at 2:47 am
You'll need to import the spreadsheet into a table first. Use the Import/Export wizard for that. Once you've got the data in a table, use the UPDATE that Jason mentioned.
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
August 31, 2015 at 10:11 am
A question for those who have upgraded to Windows 10 and have SQL and Visual Studio installed:
What the total size of the Windows and 2 Program Files directories?
I'm trying 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
August 31, 2015 at 9:01 am
My Win 7 machine's got to the point of bluescreening about once ever 2 days with a System Service Exception (or something like that), so it's going to have 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
August 31, 2015 at 7:27 am
Grant Fritchey (8/31/2015)
briankwartler (8/31/2015)
Which ORMs do you have experience with? I would think that the designers of these ORMs would very much like to hear of your...
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
August 31, 2015 at 7:26 am
Viewing 15 posts - 4,861 through 4,875 (of 49,552 total)