Viewing 15 posts - 3,316 through 3,330 (of 9,725 total)
In that case, I'd make sure you have enough RAM for both instances to be up (when the other server fails) and still be able to run the OS, etc....
October 31, 2013 at 7:53 am
I don't advise using the same server for a warm standby of your primary database. If you lose the server, you lose both the primary and the stand by.
October 31, 2013 at 5:01 am
According to Brent Ozar's blog (in the comments) it's 64GB per instance. But you should read his reply to that comment.
http://www.brentozar.com/archive/2010/06/sql-server-r-standard-supports-less-memory/%5B/url%5D
EDIT: You should also consider what will happen to the...
October 31, 2013 at 4:50 am
Speaking of maps and geospatial data, which is a better type of data to use? Raster or Vector?
October 24, 2013 at 5:09 am
The entire structure depends on your data, what you're keeping, etc.
The way we have ours designed is by using versioning. We keep a "main" table that is narrow and contains...
October 16, 2013 at 9:34 am
SQLMaister (10/15/2013)
Select count(*) is the most efficient and correct way.
Careful there. Absolute statements like this can get you into trouble in the DBA world.
The "correct way" depends on what you...
October 16, 2013 at 4:47 am
Charles Kincaid (10/15/2013)
Brandie Tarvin (10/15/2013)
October 16, 2013 at 4:45 am
Mighty (10/15/2013)
paul s-306273 (10/15/2013)
Who'd have thought count(*) would generate so much debate...
I agree, and that apparently nobody uses a where clause while counting, but that they only are interested in...
October 15, 2013 at 8:37 am
Interesting results on the execution plan. All plans but the COUNT() on Name came backup with only an expected 9B in the row size. The Name count came back much...
October 15, 2013 at 7:30 am
The best way I've found for using COUNT(MyCol) is to use either the identity column or the primary key column. That way there are no NULL results to worry about.
SELECT...
October 15, 2013 at 6:37 am
This is interesting. To install BOL, one has to go into the Help menu (Manage Help Settings) and choose from a whole bunch of different documents to download and install...
October 10, 2013 at 8:15 am
GilaMonster (10/10/2013)
Brandie Tarvin (10/10/2013)
GilaMonster (10/9/2013)
Brandie, do you have any writing tools that you'd recommend, for tracking characters, places, plot segments, stuff like that? Preferably for iPad and PC.
I use StoryBox...
October 10, 2013 at 6:59 am
Greg Edwards-268690 (10/10/2013)
Based on your reaction, there could be either a chuckle, or a spew on monitor moment.
Really? That explains the coffee leaking through the sides of the webcam. I...
October 10, 2013 at 6:45 am
GAH. I hate the Upgrade Advisor.
Analysis Complete. 4 Total. 3 Successes. 1 Warning.
The warning is the first action (Analyze SQL Server) and it makes me go to a report that...
October 10, 2013 at 6:11 am
Greg Edwards-268690 (10/10/2013)
Check this out.
So if anything, I would install afterwards.
Was it giving you a warning during installation of Dev Edition?
Or was...
October 10, 2013 at 6:02 am
Viewing 15 posts - 3,316 through 3,330 (of 9,725 total)