Viewing 15 posts - 9,946 through 9,960 (of 39,769 total)
February 24, 2015 at 10:19 am
You might read this to ensure you understand: http://www.sqlservercentral.com/articles/Administration/64582/
February 24, 2015 at 10:17 am
azhuravel3343 (2/24/2015)
Mr StrangeI appreciate the information but it also would be helpful to list title/ISBN of Itzik Ben Gan book that you are referring to.
There are a few:
http://www.amazon.com/T-SQL-Querying-Developer-Reference-Ben-Gan/dp/0735685045/ref=asap_bc?ie=UTF8
http://www.amazon.com/Microsoft-High-Performance-Functions-Developer-Reference/dp/0735658366
February 24, 2015 at 10:15 am
Tom has a good summary here. If someone would like to tackle a short, simple, intro piece, we'd appreciate it.
February 24, 2015 at 9:44 am
I'll also say that I think my kids spend too much time in front of screens and it makes me crazy. But my son runs cross country, my daughter plays...
February 24, 2015 at 9:24 am
phonetictalk (2/23/2015)
How do other people handle the "in moderation" part of technology? Especially for kids not yet in school?
My three kids are older (13+ now), and so we've given up...
February 24, 2015 at 9:10 am
djackson 22568 (2/23/2015)
...Minecraft is about building, and having fun doing so.
...
Very true. Late to respond, but my experience with my two younger kids is that they were much...
February 24, 2015 at 9:03 am
You can also query the backup files and look at the LSNs to do some matching to determine what's the latest. Ultimately that's the best. This script might help you:...
February 24, 2015 at 8:41 am
I'd lean towards what Gail mentioned. If you need inserts to happen without affecting reads, then isolation is probably the best way. However this changes where resources are needed on...
February 24, 2015 at 8:39 am
GUIDs are very unlikely to collide, but there have been reports of this. It's not something to worry about in practice, but be aware.
These certainly are important for things...
February 24, 2015 at 8:37 am
Deadlocks typically occur when you have two processes accessing data in different orders. It could be UPDATEs, but SELECTs could cause issues at times.
However if you have different users accessing...
February 24, 2015 at 8:34 am
What's the specific message or problem? Ken might be on the right track here.
February 24, 2015 at 8:27 am
That's what a user asked for.
I think that there shouldn't be any difference between a PK and unique index, whether CI or NCI, but perhaps there's some misunderstanding out there....
February 20, 2015 at 7:08 pm
Miles Neale (2/20/2015)
February 20, 2015 at 2:34 pm
Viewing 15 posts - 9,946 through 9,960 (of 39,769 total)