Viewing 15 posts - 451 through 465 (of 832 total)
It depends which edition you have installed. SQLEXPR.EXE is for Express Edition, while SQLEXPR_ADV is for Express Edition with Advanced Services. SQLEXPR_TOOLKIT.EXE contains the Management Studio Express and Business Intelligence...
September 28, 2011 at 5:07 am
As far as I know this message is actually informational--it means the server didn't need to use a cursor to perform the specified operation, it just ran the SQL directly.
September 8, 2011 at 3:37 am
Out of interest, what are you *expecting* to get back when you compare a Boolean column to an empty string?
September 7, 2011 at 3:54 am
bill.saunders1 (9/6/2011)I've always been driven by location, since I work to live, not live to work.
Which is exactly the reason I live where I do...when I'm not at work, I'd...
September 7, 2011 at 1:05 am
cengland0 (9/6/2011)
The most commonly selected answer (so far) is "Query 3 and Query 4 will fail" (28%) which means many people think it's okay to put an order by clause...
September 6, 2011 at 6:49 am
Knew 4 would fail, but never heard of the problem that would cause #1 to not work...always nice to learn something new! (I mean, I realised the ORDER BY in...
September 6, 2011 at 1:39 am
If I lived closer in to the city centre it would probably be fine...I could use the Metrolink tram (Manchester), which has been OK the few times I've used it....
September 5, 2011 at 12:54 am
GilaMonster (9/2/2011)
Depends on what kind of disaster, what it damaged and what it left intact.
Would it make a difference if you were able to take a tail log backup of...
September 5, 2011 at 12:44 am
GilaMonster (9/4/2011)
I'd love to commute some other way, but in a city with no good, reliable, safe public transport that's a dream. It's walk, bike or drive, or don't go...
September 5, 2011 at 12:42 am
With the information provided the only possible answer is "it depends". For example, if this 100Gb of data hardly ever changes, you'll not need a very big log file and...
September 2, 2011 at 8:25 am
jay holovacs (9/1/2011)Really really silly because the parking lot at this building is more than ample, it is never, ever filled.
That actually brings me to mind of the place I...
September 1, 2011 at 7:52 am
True, but since you need to switch it back to full recovery and then take a log backup--which, as the article said, will easily be the full 50Gb and change...
September 1, 2011 at 4:02 am
This is one of those questions where the common sense answer (e.g. both tables have no data in, so of course the answer will be zero rows!) is actually right...I...
September 1, 2011 at 1:00 am
I regularly work at two offices, and in both places I park in a position where I know I can get back out easily without having to make more than...
September 1, 2011 at 12:57 am
Nice article, but it just reinforces a query I've had for a while: why does bulk-logged recovery mode even exist? It has some hefty downsides compared to full recovery, and...
September 1, 2011 at 12:53 am
Viewing 15 posts - 451 through 465 (of 832 total)