Viewing 15 posts - 11,806 through 11,820 (of 39,963 total)
There was a problem with some information missing in the article. My apologies for that. I have corrected the text.
October 29, 2013 at 10:59 am
Welcome, and as Keith noted, more info is needed.
Your explanation isn't really clear to me either. What is the range you are avoiding, what are the edge cases and exceptions?
October 23, 2013 at 9:24 am
You could use osql/SQLCMD to do this as well.
Use the START command in a command prompt to spawn a process running your query and run that twice consecutively. It will...
October 22, 2013 at 9:49 pm
I've used ERStudio and liked it. CA ErWin works, but the last version I used (2002-3) was cumbersome. Visio can do some, but cumbersome as well.
October 22, 2013 at 9:40 pm
Gary Varga (10/22/2013)
1) There is no existing post that already covers what I would say (although consolidation and/or simplification are viable reasons to...
October 22, 2013 at 8:49 am
tabinsc (10/22/2013)
Thank you Steve for this article. This is something I need to do but haven't done yet. I guess writing the first one is the most difficult.
It...
October 22, 2013 at 8:36 am
Pause the log shipping jobs that restore. Let new logs continue to be run on the primary and copied over.
Bring the DR database online (with recovery) and test if things...
October 21, 2013 at 8:35 pm
+1 to what Sean wrote. You might index on these four columns if that is how you access things, but that doesn't necessarily relate to the PK.
October 21, 2013 at 1:12 pm
I'm not quite sure what you mean by a link to another system. Are you looking to query MySQL, Oracle, or some other system from within SQL Server?
You can look...
October 21, 2013 at 1:10 pm
Read this and post some DDL/DML and we can likely help. As noted, however, the design probably needs work. If you can't change that, give us some setup and we'll...
October 21, 2013 at 10:06 am
Ray K (10/21/2013)
(P.S. Steve, did you change your profile icon just for this thread? :-P)
Nope, should be changed on all threads. At least, I hope so.
October 21, 2013 at 9:59 am
You shouldn't have twitter on all the time. I'd check it 5 minutes a day, maybe see if there's something to interact with, and ignore it the rest of the...
October 21, 2013 at 9:58 am
Don't get caught up too much in the R5 penalty. It certainly is a bigger hit than R1/R10, but I've run SQL Server databases for years on R5 and it...
October 21, 2013 at 9:52 am
Miles Neale (10/21/2013)
I got a twitter account two years back and have used it just a little. The entire experience was useless.Maybe it is time to try again.
M.
You need...
October 21, 2013 at 9:49 am
Viewing 15 posts - 11,806 through 11,820 (of 39,963 total)