Viewing 15 posts - 11,761 through 11,775 (of 39,963 total)
both Ed and Gail have given good resources.
the other thing I'd suggest is that you create a test copy of your db, run some queries, add indexes, and re-run them....
November 8, 2013 at 11:39 am
Jeff Moden (11/7/2013)
"Doing it right the first time" shouldn't be just a motto. It should be the best of all practices.
What's "right"?
Jeff, overall I agree that we should...
November 8, 2013 at 10:27 am
roger.plowman (11/8/2013)
And that's why "good enough" leads to HealthCare.gov type solutions. Sure, you can have bad developers who don't understand all the parts of the system and why certain approaches...
November 8, 2013 at 10:25 am
It's not working for me either. No idea why. I've submitted a bug.
November 8, 2013 at 10:22 am
Interesting. Wonder what some you think?
https://www.schneier.com/blog/archives/2013/11/why_the_governm.html
November 8, 2013 at 10:05 am
webrunner (11/8/2013)
By the way, Steve, congratulations on your whirlwind tour. That sounds like a crazy amount of travel and work!!
Thanks,
webrunner
Thanks. It was crazy, fun, and exhausting.
November 8, 2013 at 9:54 am
If it's a PK, you can't have a violation. However, not sure if values are reused.
November 7, 2013 at 11:19 am
There are no grants for encrypting/decrypting data. This is controlled when a user can open a key that performs the function. This could be in a stored proc or with...
November 7, 2013 at 10:23 am
GilaMonster (11/7/2013)
If you try a RESTORE LOG on a database that's online, all you'll get is an error (no files are ready to roll forward),...
November 7, 2013 at 10:21 am
Not sure how things are allocated, but databases are limited to the 2B object limit.
http://msdn.microsoft.com/en-us/library/ms143432%28v=sql.120%29.aspx
November 7, 2013 at 10:17 am
I'd set it to single user or restricted user, with immediate rollback and then restore. This is what sestell1 suggested as well.
That way I can Check things before/after the restore...
November 7, 2013 at 10:15 am
There are probably more, but I'd make a rational argument that part of the reason schedules are missed is because developers are not allowed to develop comfortably. They should have...
November 7, 2013 at 10:07 am
Tom John-342103 (11/7/2013)
November 7, 2013 at 9:55 am
Pros, you can upgrade dev machines and easily move to other/new developers. You can work at home or remotely without changes.
Cons - bandwidth needs to be there. If there are...
November 7, 2013 at 9:52 am
I think this video also has some numa explanations: http://technet.microsoft.com/en-US/sqlserver/gg508899.aspx
As Gianlucca said, the idea is that memory is linked to a node so that it ensures resources are available for...
November 7, 2013 at 9:50 am
Viewing 15 posts - 11,761 through 11,775 (of 39,963 total)